-
How record a date automation work?
Hi, I'm having trouble using the record a date automation. as you can see in 1st picture, I create record a date when "send noti to slack" is checked in 2nd picture, every change I made in that check box is from 25-Nov-2021 but record date show 24-Nov-2021 does anyone know why? and what I have to do to make it record the…
-
Trying to find a way to update information on existing rows via a form (not via update request)
Hello Smartsheet Community. I have a customer who has uploaded an existing excel spreadsheet into Smartsheet (about 200 rows) which includes information such as email address, first name, last name, etc. as columns. We have created a form to capture new information to each row. Is there a way to set it up so that the new…
-
Customized button text not reflecting on approval workflow
Hi, When we customize the button text under 'Approval Workflow' it still shows default values i.e. 'Approve' and 'Decline'. Is there any workaround available.
-
Is that possible that Smartsheet automatically writes hierarchy numbers for tasks level ?
-
Workaround for Sheet Reference Limit?
Hi everyone, On our project we have two sheets, a project plan which contains around 50 items, each containing around 9 sublevel actions. We have a separate sheet that we were manually maintaining in excel containing all of these sublevel actions organized in rows based on the 50 items. Our goal is to have this sheet…
-
How to include an if statement
I have a vlookup formula. =VLOOKUP([Attribute Name]@row, {Standards List - Enhanced - Business Rules Range 1}, 4, false) . I need to be able to use this formula and check another column based on the version number. I need it to pull in x if it matches the name and version number.
-
How to create children in large sheet automatically
Hi! I'm new to SmartSheet and not very good with Excel 😪. I have a sheet with over 18,000 rows that I would like to make any cell in the primary column with a date a parent of the rows beneath. I used an excel formula to find and add the date to the Primary column based on blank cells and a separate Event Date column (see…
-
Conditional Formatting using a custom formula?
Hi there, So I'm trying to set up conditional formatting to visually alert us if 3 days go by and we haven't followed up with someone. My idea is to make an "Estimate Sent" cell which records the date we sent an estimate and turn it red if we haven't checked the "Estimate Approved" column after 3 days go by from the date…
-
University Permit or Special Event Request From
Hello, I am wondering if anyone in this group uses Smartsheet for Permit or Special Event applications? We are looking to utilize Smartsheet to streamline our Alcohol Permit process and I wanted to see if anyone is already using Smartsheet for something similar. Thank you in advance!
-
Reference Codes
Hi, I am looking to have a single reference code or number that is attached to an update request that contains multiple rows. Is there a best way to do this? My first thought is to have a value added to a cell when the reference goes out, is there a way to make this a rolling serial number as each update request is…
