-
View All Formulas Used in a Particular Smartsheet
I would like to see a list of all the different formulas that are used--along with which cells are affected by these formulas--on a particular smartsheet. Is there somewhere I can view this?
-
Notification on Formula or On Status
It appears that it is not possible to send a notification based on a formula if the sheet has not been opened/saved. Is there a work around within Smartsheet? Is it possible to send a notification every day on any rows that have a particular status (e.g., Open)? It seems there is no trigger (no row change/add). TIA
-
Change Status dropdown when task is assigned
Hello, Smart People I have a [Status] dropdown which includes Assigned, In Progress, In Review, and Complete. I would like to automatically change that status to Assigned as soon as the [Assigned To] column is not blank. I've found how to change status harvey balls or completion ramps, but not text-based dropdowns. Seems…
-
My formula works fine with no errors, but no value appears. What is the issue?
I am using another sheet for the lookup_table. The other sheets basically has the currencies and the rates of each currency. What I want to do in the sheet where the function is; basically once a row is added and the currency has been selected, I want it to generate the value of the currency from the other sheet.…
-
Need a way to identify if a row has been approved/rejected via proofing
Hi, I am using the new feature "Proofing" for my upcoming project and I was wondering is there any way to identify if a document on a row is approved/rejected, then use it in the custom formula to change the status of the row? For example if a document is rejected then I would like to change the status of the row to…
-
How can my rows autofill the formulas when a new entry is generated through a form?
I have worked out several formulas in my sheet. Now I want them to be autofilled whenever a new entry is filled through a form. I don't want to drag them manually everytime there is an entry because I want automated workflow to follow. Also, if I drag a couple of cells prior to the forms being filled, then what happens is…
-
How do I check for duplicates under a parent?
Hello, How could I check for duplicates (children) [Item Number] under a parent [123456]? Note: All parents will be a unique number value, but the Item Numbers will often be the same/repeat across the parents. I need this to check for duplicates under each parent.
-
If there are duplicates for a corresponding Primary Column, I want computation to appear only once
Hi, I am trying to find, how many Promotions are for a particular item for a particular Start Date. Example: Promotion || Total Number of Promotions for Start Date || Start_Date Bacon || 1 || 2/4/2020 Chocolate || 3 || 3/14/2020 Chocolate || 3 || 3/14/2020 Chocolate || 3 || 3/14/2020 Chocolate || 1 || 2/14/2020 Above table…
-
IF(AND) Statement With List of Expressions
Hello, I'm a fairly new user to Smartsheet and trying to put together some formulas. I'm currently trying to implement a formula to summarize a column called Status if the rest of the cells in that column have a "Complete" entered in them. If there is at least one cell with anything other than "Complete", I want…
-
Forms and Formulas - Form add a row to top but formula does not include
I have a smartsheet that I want to use for team holiday requests.The team would fill in a form that add their request to the top of the smartsheet. Further down the smartsheet is a summary, by team member, of their total holiday allowance, calculated by formula of the number of days requested (and approved) and number of…