in the last line the sum of the results from the following formula not appears:
Blockquote ifs({Alter}>18, 1, {Alter}>12, 0.6 ,{Alter}>0, 0.3)
or
Blockquote ifs({Alter}>18, “1”, {Alter}>12, “0,6” ,{Alter}>0, “0,3”)
in the last line the sum of the results from the following formula not appears:
Blockquote ifs({Alter}>18, 1, {Alter}>12, 0.6 ,{Alter}>0, 0.3)
or
Blockquote ifs({Alter}>18, “1”, {Alter}>12, “0,6” ,{Alter}>0, “0,3”)
Hi, you need to describe the problem with a little bit more details so that people here can understand you.
Thanks. It’s crystal clear now.
I think the problem here is that, the formula result of “1” is considered as text
instead of number
. Let’s see what we can do and I’ll come back to you as soon as possible.
Is there a way to copy the values into a new column and convert them as a number?
As a temporary solution
Hi, thanks for the patience. We’ve solved this problem in 2.3.3
And the good news is, 2.3.3 will be released very soon!
perfect. thanks for the fast solution
This topic was automatically closed 2 days after the last reply. New replies are no longer allowed.
Do it like thousands of other people who have used SeaTable to develop powerful processes and get their ideas and tasks done more efficiently.