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!
I submitted a ticket, but thought I would ask here. I am having an issue with sheets that I own (our org is on a Business plan). For the last two years, we have been using the sheets without an issue - our admin and many Editors (all shown as Guest since they are outside of our organization) were able to edit the sheets…
Hello! I’ve noticed for a LONG time that when I change the name of a column in a source sheet, the corresponding column in reports breaks, which then causes dashboard widget charts (that rely on those reports) to fail. Is there a way to: Prevent this issue when renaming columns? Fix existing reports and dashboards without…
Dear All, my account was suspended for a long period in which my sheets were deleted. I renewed my account and asked technical support if my sheets could be recovered. I received this message below, but I do not seem to get a reply back afterwards and still do not have my sheets recovered. Thanks for…