-
Control Center Find/Replace formula not working
I am trying to do a global update within our Blueprint on just one sheet in the summary section. All sheets have the same column name and the same row. We are trying to change the last "Description$8" to be "Description$12." When I look at the test sheet, it still has the "Description$8."
-
Ranking when duplicates
I need help with a challenging formula. I have the following situation: Row# Value Score Effort Score Priority Score Rank* 1 50 5 45 4 2 70 10 60 1 3 65 5 60 2 4 60 20 40 5 5 70 25 45 3 If Priority Score = Value score - Effort score then rank by priority score (with greatest priority score = rank 1) if priority score is…
-
How do I use AI for Summary formulas
Hello - I am trying to set up some Summary Fields and the formulas needed are a bit above my skillset. I use the AI assist to generate a formula, but I cannot figure out how to add to Summary fields rather than to a specific cell on the Sheet. Also, I am getting error messages on formulas that seem logical and pretty…
-
Smartsheet Solution - Dynamic Configurations
We are trying to develop a Smartsheet solution to replace an Excel file that is bursting at the seams and is running slowly due to the number of columns and rows. The existing Excel spreadsheets break down configurations, determining the number of units based on total volume and percentage. The ultimate desired end state…
-
Days late formula not working??
Please see my formula below - it has been working correctly i believe until i finally had something go past due. Instead of just showing -1 it shows as -3? Can someone help me fix my formula?
-
Using INDEX/MATCH for a Master Sheet
Hi all, One way we use Smartsheet is to record real-time data that is then stored and referenced. I work at an aquarium so, for example, we will take daily measurements across multiple systems for things like temperature, salinity, pH, and on and on. The same parameters are tracked for all of our systems, but the thing is,…
-
Formula not Calculating the Correct Number
Hello, I have a formula that counts notifications that are tracked on another smartsheet each month. The formula is: =COUNTIFS({Date of Notification}, >=[Start Date]@row , {Date of Notification}, <=[End Date]@row , {Impacted Department}, <>"XX") The results from this formula are no longer calculating correctly. For…
-
Combining data from 3 different columns to create a summary report
Hi all. I am trying to create a summary repot that combines 3 columns that I have on an Intake Sheet and Archive sheet. The data that is in each of these columns are pretty much the same, but we have them separated out based upon on the different clients that we have. Within these 3 columns, it has Job type data (i.e.…
-
Formula Assistance - Unparseable
Hello, I am trying to create a formula to count the amount of times 0, 1, 2, 3, 4, 5 were answered for each of the column categories wihtin the last three days to display on a graph on a dashboard. I was successful in creating the formula in a sheet summary, but cant get that to display correctly on a dashboard graph. So I…
-
Download Column Names & Column Types
We are making a master sheet to combine all of our 15 intake forms and sheets to help track metrics and more easily send intake rows/projects amongst teams once their portion of the project is complete and/or work on a project simultaneously. Is there a way to only view the columns for each sheet and their column…