-
Can I save the settings for an update request?
I have a sheet with many columns When I send an update request most of the columns dont apply (they are for later in the process). This means I have to edit the uodae request and untick the columns I do not want to send. Is there a way to save the settings (unticked columns) for subsequent update requests from the same…
-
I seem to have lost my cell history in only one of my sheet. How to get it back?
I have a sheet that is the main data base of a whole system and multiple people and formula update. It is very useful to have individual cell history. It has stop working yesterday(21 sept 2022). Any of you had that situation? (Activity log is still operationnal)
-
How does a record in a sheet from a form submission just disappear?
Hello, I designed a request form for a team that included a copy of the submission to be sent to the submitter's email once the request was submitted. The submitter submitted a request, received a copy of the submission, but there was no record of the submission in the backend sheet that is connected to the form. I looked…
-
How to overrule a 0 multiplication formula returning 0 as an answer?
Hi all, haven't been able to find anything on this by searching so I'm posting. I'm hoping it is a simple fix as the formula seems very simple! I am attempting to calculate accident frequency rates at my company. I fully understand that anything multiplied by zero returns zero. However, if there have been no accidents I…
-
How to copy a column data of a source sheet to a target sheet.
Hi All, Step1 - I would like to copy the column data in a source sheet to a target sheet. Step 2- After the data is filled in the target sheet column, I will then run a data mesh config to pull the rest of the column data by matching a data I copied in step 1. Below is some screenshots of the sheets: Coulmn114 data is…
-
Struggling with IFERROR syntax in nested formula
I've finally gotten this INDEX/MATCH formula to search 2 sheets and return the correct result but I'm struggling with the IFERROR portion. I think I need a second nested IFERROR. I would like the cell to remain empty if no result is found instead of the #NO MATCH result that currently appears. =IFERROR(INDEX({Clinical…
-
Enhancement Requests: Freeze Row, Merge Cells
Understand that Smartsheet functionality is heavily built around columns, however if Smartsheet has to standout with the likes of Excel and Google Docs then features like Freeze Row, Merge Cells needs to be supported. For example, if the user wants to simply add a title that spans across 4 columns that represent months in…
-
Identify Duplicate Values On Select Dropdown Selections
I want to identify any new rows that are trying to use the same filename as an existing row. We do have reuses, so I do not want those flagged. I was able to set up a checkbox helper column for Duplicates that identifies any filename that is repeated in that column. =IF(COUNTIF([Filename]:[Filename], [Filename]21) > 1, 1,…
-
Need some help with a health formula for task risk level analysis
Hello, I am currently working on a formula for the health column in my smartsheet that is based on the the task status and the end date of that particular task. This is what I have so far but what I need is for when the "end date" cell is blank I would like for the health of that task to be blue. The reason is we do not…
-
sheet count?
Is there a way to get a total of the number of sheets currently in an account?
