Sign in to join the conversation:
Hello,
I am trying to have the dates auto-populated in the SmartSheet when I add data on a new row. Is that possible?
Thanks,
Hi Roshan,
Can you describe your process in more detail and maybe share the sheet(s) or some screenshots? (Delete/replace any confidential/sensitive information before sharing) That would make it easier to help. (share too, andree@getdone.se)
Have a fantastic week!
Best,
Andrée Starå
Workflow Consultant @ Get Done Consulting
Have you tried the Auto-Number/System --> Created (Date) type column?
@Paul Newcome
The auto-number/system --> Created (Date) type column also displays the time. This becomes problematic if that info is then used in charts. The column cannot be graphed with both the date and time in the same column. Any workaround?
You can use a helper date type column and just use
=Created@row
This should strip the time out.
Hi All, I’m looking for some guidance on how to best structure an activity plan in Smartsheet. I need to track and display: Date ranges for each activity Activity month Monthly budget Key points such as promos/offers Major events happening during the same period (e.g., national holidays, International Women’s Day, etc.)…
Is there an easy way to quickly drag down the same cell values to 1,000+ cells? Important: I have the sheet filtered, as I only want this to be copied to specific rows. I have over 1,300 rows on the sheet, so I can't just use the column formula functionality. I was hoping I could just double click the bottom right corner…
Greetings Smartsheet Wizards… I have created an automation that is supposed to only copy rows if a particular column is blank. The conditional block is set to "where column name is blank". However, the automation copies every row in the sheet, even the rows that contain text. Does the is blank condition not work correctly…
