You’re offline. This is a read only version of the page.
143
Hi everyone, I have a set of formula here, where I put StartDate at the ApprovalDate date picker, CompleteDate at the TargetCompletionDate date picker and severityLevel at DropdownIssueSeverity dropdown. Before this this formula works well, but somehow this error keeps popping up,
The above formula should have a result of when Level I is click, the target completion date will auto show the date after 4 days by skipping weekend/holiday and so on.
here is the sample of excel table, to read the date for the whole year of 2024, where 1 = holiday/weekend and 0 = workdays
| No | Date | Cuti |
| 1 | 1/1/2024 | 1 |
| 2 | 2/1/2024 | 0 |
| 3 | 3/1/2024 | 0 |
| 4 | 4/1/2024 | 0 |
| 5 | 5/1/2024 | 0 |
| 6 | 6/1/2024 | 1 |
| 7 | 7/1/2024 | 1 |
where Date column is in Date format, and Cuti column is in Number format.
Hi , @mel_
This error means that your CompleteDate variable cannot be converted to the specified data type.
For example, we can not convert the number type to the Text type.
So in your side , you can try to just rename your variable name to another to check if it can resolve the issue.
CompleteDate --- >> CompleteDate1
If this reply can help you , you can click mark this reply as solution (Accept solution) which can help more people, thanks in advance!
Best Regards,
Yueyun Zhang
Share
Report
All responses (
Answers (
