I want to know what wrong with?

[Cynthia_Lin]

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.)

Formula was
SwitchIf(WeekdayName(Today)=“Monday”,“一”,WeekdayName(Today)=“Thuesday”,“二”,WeekdayName(Today)=“Wednsday”,“三”,WeekdayName(Today)=“Thursday”,“四”,WeekdayName(Today)=“Friday”,“五”,WeekdayName(Today)=“Saturday”,“六”,WeekdayName(Today)=“Sunday”,“日”)

Please help me, I want to know what wrong with? Thanks!

[Piet_Strydom]

Hi Cynthia,

Could you share the doc, or a copy of the table with the formula?

It is very difficult to work off a screenshot.

Regards
Piet

[Pch]

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 Text .

I think Coda is interpreting the numerals you used as text values here whereas it expects a date .

I hope this helps

[Cynthia_Lin]

Hi, Problem was solve, thanks alot!

[Cynthia_Lin]

Thanks for welcome!
It was worked! Thank you very much!!

[Pch]

My pleasure @Cynthia_Lin !
Glad to know this now works as expected !