Sign in to join the conversation:
Hi all
I have a date column that is a formula (10/12/18 + 60 = 12/11/18) I need to add 6 months to that date, but when i try to add 182 to the 12/11/18 date i get Invalid Column Value. What am i doing wrong?
It sounds like your column property is set to Text/Number. If you click the arrow underneath the column header it should say Current type: Date at the bottom. If it doesn't you can Edit Column Properties there.
figured it out... the column was not a date column... all good now.. thank you!
Hello all, I have a weekly report that I'm building and would like to be able to only expose two weeks worth of status. The report has a status and a commit date column and I'd like to remove anything that is "Done" and more than 2 weeks old. I'm trying to avoid having a report that has 100 rows of tasks that have been…
When I print my dashboard, the color coding next to the divisions disappear. Any clue to a fix?
Is it possible to sort a report widget in dashboards? We have data that could be sorted by date or by location name depending on the use case. Is this possible? I know the underlying sheet can be sorted by column, but I can't see a way to sort the data in the report widget.
