-
Formula returning #nomatch when flash filled (original formula does not have error)
Hello - I wrote an IF(Index(Match formula to reference a checkbox between 2 sheets (if checked in reference sheet, check in target sheet). The original formula works, but when I attempt to fill the formula down my column, it starts throwing #NOMATCH errors. I tried re-typing the formula from scratch, but no luck. Target…
-
Why does my range change?
Every time I complete a formula the word TEMPLATE appears in my range, but does not appear in my sum_range. Is that normal? =SUMIF({Template of Sidewalk Database Module Range 1}, "Completed", {Sidewalk Database Module Range 1})
-
Formula don't work in reports
Hello, I have formulas working properly in the sheets, but not in the report. For example, when a task is "Complete" in a sheet, the done checkbox is ticked and the dot gets grey; when I do the same in the report, only the status is updated. Similarly, in the sheets a formula makes the dot yellow 15 days before the end…
-
Formulas in reports don't work
Hello, I have formulas working properly in the sheets, but not in the report. For example, when a task is "Complete" in a sheet, the done checkbox is ticked and the dot gets grey; when I do the same in the report, only the status is updated. Similarly, in the sheets a formula makes the dot yellow 15 days before the end…
-
How do I create recurring questions to repeat a series of questions if the person selects yes?
How do I ask a question if the answer is yes then a series of questions will be repeated. For instance, If I ask, Do you want to add an additional widget?, then a series of questions will populate. Questions could be: Color, Size, Weight, Dimensions, Number, etc. Then we would ask the same question again, Do you want to…
-
Limited characters for a condition within a workflow?
Hi, I am working on setting up a workflow in my Smartsheet. One of the conditions I want to setup is from an existing drop down menu I created in the Smartsheet. Within this drop down, there is an item with a longer title that does not show up as an option to choose in the Condition portion of the workflow. Is there a…
-
Form Submission creating new row - cant do notification
I have a sheet which has 10 columns. It is meant to collect data and trigger notifications. The first 4 columns, I have created a form to collect data from user. The 6 other columns are for tracking on status and assigned to user column. The last 6 columns are meant to be fixed (content doesnt change). So when a new form…
-
Assigning People using IF Formula or the new Assign People Workflow?
I am setting up a request register where the client logs a request via a form. I want to then notify specific key people depending on what account the request is for to review the request and work on next steps. The people sit in 3 key groups. Account Manager, Commercial Manager & Project Manager. At the moment I have set…
-
Supplier management
Hello. I would like to monitor a group of suppliers to whom I send a questionnaire. Is it possible to automate a mailing every 6 months, for example ? Is it possible to send 2 attached documents via Smartsheet ? How can I do this ? Is it possible to manage the return of this questionnaire in my database ? How can I manage…
-
I am wondering how I would add an If to a formula to add an additional approval layer when needed.
I had a simple 4 person approval process that looked to see if 4 people selected "Approved" it will make a cell as "All Approved" and send an alert. Current Formula: =IF(COUNTIF([Jim Approval-RD]@row:[Angela Approval-RD]@row, "Approved") = 4, "All Approved", IF(CONTAINS("Declined", [Jim Approval-RD]@row:[Angela…