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.
I am wanting to send a request for an update to our inventory control people when we have non-conforming material that needs to be contained in the system and physically. I have a column for each with a drop down of Yes, No,N/A. I have my automation setup for triggered when containment required changes to any value,…
I'd like to be able to enter a unique value in a form and have it prepopulate a few other areas of the form. For example, I'd like to enter an employee ID number in the FORM, and once entered the First and Last Name sections of the FORM would automatically populate with the correct information.
Hello- There's been a few question/discussions on this topic, but they are a but they are older posts. I'm trying to record the email/name and date when travel requests are approved. I'm capturing the approved date with a Record Date Automation, so that it easy, but the approved by field is getting messy. I'm currently…