Hi All, I am developing a system that involves a large workflow of approvals. I have it set up so that the user selects a person for each approval to go to. However, I want to be able to have the pers…
I have several grid sheets that have SUMIF summary formulas running. I’m working on a new sheet that requires I split the date & time that are included in one column. Summary formulas I would ordinari…
Hello smartsheet Community! I'm trying to have a status column update based on three approval columns. There's several reasons why a row would be green ("Yes"), yellow ("Hold"), or red ("No"), so I'm …
Hey All, I am having some difficulty getting a formula to work the way I want to here. I want all children rows to look at the due date column and if it is overdue, mark the status as "Red". If todays…
I have been trying to create a formula that uses two data points that will have a different status based on if it is before or after it's need by date. This is what I currently have: =IF(([Quantity Or…
We are currently evaluation Smartsheets (and others) for our team. Smartsheets feels very intuitive. The one thing I like are the symbols for completion e.g. the bar or the pie symbol, but then I'm st…
The way the sheet is currently setup, each row is a different job. there are no parent or child lines. I am trying to set a milestone date from one department task to another. However, the formula doe…
The reason for asking is we are creating a smartsheet with form for training candidates to register their names, which will then create a certificate using document generator. In order to get the cert…
My sumif formula keeps coming up unparseable and i can't figure out why. I'm not even getting the highlighted frame for when I identify the column I want to be summed. What am I doing wrong? =SUMIFS([…
Hi, I'm currently calculating if something is a duplicate by using the following formula: =IF(AND([PASS NUMBER]@row <> "", COUNTIFS([PASS NUMBER]:[PASS NUMBER], [PASS NUMBER]@row) > 1), "Duplicate", "…