Connect with peers, share your expertise, and inspire what’s next in Smartsheet — from proven practices to practical how-to insights from fellow users and product experts.
Sign in to join the conversation:
Good Day All:
Is there a way to Auto-fill dates? For example:
04/30/18
05/31/18
06/29/18
Thanks
You could create the first date in the row... then in the 2nd row add this formula in the date column =[date column name]1 + 30
That will calculate your 2nd date, then you can drag down the bottom-right corner to populate the rest of the dates.
Do note that if that first date disappears or changes it will affect the rest of the dates.
Got it, Thanks!
You're welcome! Glad I could assist.
I've created a dashboard with multiple graphs using data from the same report. I have added the report to the dashboard as well and set up the filter for use in the dashboard. Is this filter transferable to the graphs as well, given i can filter the report in the dashboard?
Dear Community, Can you please advise? I have a sheet where among other columns I have a column listing contacts "Champions" (multiple per cell) the other columns are for example: Countries (a list of 72) The list of Projects (approx 15) - I can add to that sheet, or I can create in a Helper Sheet. I haven't done that yet…
Looking for assistance again, I want to bring in the % complete from the Production sheet to the Schedule sheet, but once the % complete is 100 the data is moved to another sheet, so I would like to reference to check 1 sheet for percent complete and if it is not there check the second sheet. Schedule sheet: Pick Up Date…
