HI, I am creating a sheet for our billing department. The sheet is based on the information entered/updated on another sheet. I did link the entire column of the main sheet but the information is not …
Total noob here. I have a master sheet with 4 critical dates in regards to completing a major project (new restaurant opening). The critical dates are subject to change as some parts of the project ar…
Hello! I'm trying to auto-generate IDs that build off of another ID. The formula I'm currently using is: =[Initial ID]@row + "-R" + COUNTIF([Initial ID]:[Initial ID], [Initial ID]@row) I would ideally…
Hello Smartsheet Masters, I am making a scheduler sheet for equipment slots. The sheet contains these columns: Conflict (Checkbox), Row (Dropdown list), Slot (Dropdown list, multi-select enabled), Sta…
Hello, In my Smartsheet sheet, I'd like to set up a system to check off meetings automatically. I'd like to enter a date (ex: 04/15/23) in a column and the time span in another column (ex: 12:30 - 2:3…
Good morning, I'm trying to create a form in for entering and/or removing equipment from our site. There are times we have new equipment installed where equipment is not removed, and vice versa, but a…
I am currently using the Return to Workplace template set. I want to modify the formula being used on the Employee Main List Sheet to only collect trainings attended if the column next to it says a sp…
Hi all, I am trying to set up an email automation to email myself the contents of a contacts field for all the rows on my Smartsheet. They way I have it set up now, it is only sending me the first row…
We want to create a Smartsheet that is automatically populated with Subject, Location, Date, Time, Duration when we invite an alias to a meeting. Is anyone aware of a way to do this? We would do this …
I think an automated alert to notify system admins when an automation on a sheet is turned off would be a good feature. We have had them accidentally turned off, or on purpose sometimes even, when the…
