hello new to smartsheets. i am looking to make a V lookup that will crosslookup on 2 sheet to tell me if it is on that sheet or not. this is what i come up with so far. =IFERROR(IF(ISBLANK($[Cable Nam…
Hi! I am creating a project where there a lot of tasks and predecessors. I created a box check column and would like to put a formula where when a row have all their predecessors statue to complete, t…
Hi, I am trying to figure out how to create one workflow where based on the dropdown value selected, it would send the appropriate alert. Example Stakeholder decision (Options - Approved, Denied, Defe…
Hi, I want to update the cell value by 1 on the 1st of every month. Suppose the current value of my Earned Leave Column is 10, on the 1st of every month I want to increment it by 1.
Hi, I have row with either one or two PDFs attached that the document builder just created based on the data from the row. I'd like to add an automated trigger to send the attachments to the user (con…
Hello, I have a column formula that calculates the number of days between a ticket request and the completion date. I want the rows that do not yet have a completion date to be blank instead of "#INVA…
I have created this Smartsheet, where my team can record orders raised each month. This would then link to a dashboard (which would have to update automatically each month) to show monthly statistics …
Hi, everyone; first post, Intermediate user. I'm hoping you can help me. I've set up a SS to send an approval request when a new line is added to the sheet from a form entry. I've got the automation f…
