-
NEW! Your survival guide to formulas is here. Meet the Formula Handbook.
Hi Community, Whether you’re summing child rows, calculating budget minus actual, or doing cross-sheet data lookups with multiple criteria, formulas are a must for tailoring solutions to your needs. The new Formula Handbook is here to help formula beginners and pros alike. This template contains: A glossary of all…
-
Add a formula column to multiple sheets efficiently
Hi, I have a workspace with approx 1000 sheets in it - they are all based on the same template. Sometimes a user wants a new data/formula column adding to the template. I would like to know how i could then add this new column (and its formula if applicable) to all 1000 sheets in the workspace (without manually doing it…
-
Possible to create (or copy) a new column with same dropdown options from an existing?
Hi, This may be a very simple question and I'm just missing the answer somewhere, but is it possible copy a column with all the same attributes and drop-down choices, then I can just change the header label? I have a sheet that has numerous date columns, but the drop-down options are the same for each one. Right now the…
-
Nested if functions
i have 2 columns set up one is titled INS it has four dropdowns. the other is titled AMT, the amount in the amt column is dependent on the dropdown column selection which is text.
-
Converting Drop-down Date to a Date formatted value
First off, I am using Control Center to build out projects that are dependent on a central worksheet, "Weeks of…" as a drop-down source list. The "Weeks of…" is contained in a Portfolio folder in the Admin workspace. Secondly, I have a worksheet, "Weeks" that contains a number of dates, DATE. In this worksheet I have an…
-
Index/Distinct formula suddenly stopped working last week
I had a formula to list all distinct values from a column in another sheet. I was using this formula and it was working fine until last week. What could be wrong? =IFERROR(INDEX(DISTINCT({Liste de matériel Plage 1}); Séquence@row ); "") When I remove IFERROR, I get #INVALID DATA TYPE
-
Formula help - advanced logic
Please see formula below - when the planned date is less than the due date and inside the same month it shows as 'N/A'…. when the planned date is greater than either the actual day/date or the month in the due date of next inspection column it shows as 'Yes' in late booking column - when the planned date is less than the…
-
If Gant
Hi I'm looking for a way that if the Status column is changed to "In Progress" it will change the the start date to that date. However, I only want it to change when switched to in progress. Also, I don't seem to be able to do this with a Gant table.
-
Generate documents not working
the "generate documents" function is not working, it keeps hanging in the backgound job. Same with trying to download, also keeps hanging. This is accross multiple sheets, the documents are not generated. Anyone who can assist?`
-
Rows could not be added to the destination sheet because it did not have enough cells remaining
I have a blank sheet that serves as a "backup" for our main sheet. We have an automation that copies the data from the source sheet to the to the backup sheet once a week. To work around the fact that smartsheet doesn't have a built in way to delete data, we also have a blank excel file that "uploads" to the backup sheet…
-
Need Help Fixing Formula in a Timeline with Subtasks
I used this formula in the past and it worked, but I no longer want the cell to have an updated Status of "Complete" if all sub rows are marked "Complete" or "Not Applicable". I would like to change it to return a Status of "Complete" if ALL sub rows are "Complete" and a Status of "Not Applicable" if ALL sub rows are…