-
Is it best to link only one predecessor to each task or is it ok to have multiple?
I am working on a construction schedule and wondering what the best practice is for attaching predecessors. I have noticed my Gantt chart is currently a bit all over the place and I am thinking it is because I have too many predecessors for each task. Do more experienced Smartsheet users recommend only having one…
-
Create Chart Widget Using a Report (not a Sheet)
With the Dashboards, I am able to create charts from a sheet but not from a report (this requires using the report widget). I collect weekly "submission date" data from 40+ people. I have created a report that shows when the submission is due, when it is submitted, and the number of days (plus or minus) between the two. I…
-
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,…
