I write a formula with switchif, that can show today’s weekdayname.
If Today was Monday, then show 1
If Today was Thuesday, then show 2
If Today was Wednsday, then show 3
If Today was Thursday, then show 4
If Today was Friday, then show 5
If Today was Saturday, then show 6
If Today was Sunday, then show 7
(I’m not use WeekdayNumber, because I want to change other character.)
Please help me, I want to know what wrong with? Thanks!
Could you share the doc, or a copy of the table with the formula?
It is very difficult to work off a screenshot.
Hi @Cynthia_Lin and Welcome to the Community !
If the error message you get from Coda when hovering the formula (when the formula editor is closed) tells you something like : “Can’t convert the value to specified format” …
… You could try changing the data type of the result returned by your canvas formula from a
Date one to
I think Coda is interpreting the numerals you used as text values here whereas it expects a date .
I hope this helps
Hi, Problem was solve, thanks alot!
Thanks for welcome!
It was worked! Thank you very much!!
My pleasure @Cynthia_Lin !
Glad to know this now works as expected !
This topic was automatically closed 90 days after the last reply. New replies are no longer allowed.