Sign in to join the conversation:
I am trying the set up a dashboard using a rollup sheet.
I am trying to automate the start date so that it is always set to the 1st of the month or would it need to be manually changed every month?
Thanks
Dave
Give this a try...
=MONTH(TODAY()) + "/" + 1 + "/" + YEAR(TODAY())
What it does is displays the month for whatever TODAY is.
Then a /
Then 1
Then another /
And finally the year for whatever TODAY is.
Below is the result
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…
