-
How to create a dashboard pie chart from a multi-select dropdown
I have a sheet that includes a multiselect dropdown of topic areas for users to select as many as are applicable as they fill out the form. In my dashboard, I want to have a pie chart that includes percentages of each topic area that are selected. However, the COUNTIF formula does not count anytime someone selects more…
-
Trouble with long date formula
Hi, I am working on something that will tell staff when the open window for a visit is, based on the visit category. Rule 1: Visits in the category of 1, 2, 3-5, 6-10, and 11+ years should be annually and the window is their DOB +/- 1 month. This portion of the formula works. Rule 2: 3rd trimester visit should start 197…
-
Can you create a sequential countif() that also adjust its sequence number based on a countm()
I am trying to create a sequential countif. ex. =countifs(Date:Date,>Date@row,Collumn:Column,=Collumn@row. How ever I also want it to take a countm() into consideration when giving its sequential numbers. Ex Jim appears 5 times, how ever the second time a drop down has 3 selections in it. Thus the number sequence should…
-
What is the best way to set up a multiple entry item list/field within a form?
I'm not sure I worded that my question correctly, but I am trying to create a form at the moment that, in addition to several other questions/fields, asks the user to submit any income/deduction items not already set up and for each entry to give the EE Name, EE #, EE Type, Income/Deduction Name & Amount. Is there a way to…
-
Strategies for Managing Column Counting in Workarounds for Smartsheet Cross-Sheet Reference Limits?
Hello Smartsheet community, I've hit the limit of cross-sheet references allowed in Smartsheet, which has led me to adopt a workaround using formulas like =INDEX({Cross-Sheet Range}, MATCH(target_value, {Match_Range}, 0), column_index). This solution allows me to continue referencing data across sheets without adding more…
-
Inserting/Creating a Row Automatically
Is there any way to automatically create/insert a row into a sheet based on a trigger from within that sheet? Essentially, copy a row of a sheet and paste it as a new row into the sheet with a different status or different value in a few columns?
-
Dynamic year formula for the previous year
Hello! I would like to show the average score for the previous year without indicating specific year (instead of showing 2023 I use formula (YEAR(TODAY()) – 1. =AVG(COLLECT({Vendor Evaluation Sheet - Archive - Score}, {Vendor Evaluation Sheet - Task ID}, [Task ID]@row, {Vendor Evaluation Sheet - Archive - Created},…
-
Add value to a checkbox
How do I assign a value to a checkbox so that if it is checked it equals "800" and that 800 can be added to an addition formula?
-
How do I always reference a child row immediately below the parent row(In the same column)?
Probably a basic way to do this but I cant get it to work. I need the circled cell to always refer to the cell immediately below it. So the circled cell will show "OFF HIRE' from the blue row until a new row is inserted in between the 2 and then it will refer to the new row's cell.
-
Help with IFS formula
I have a Smartsheet that tracks all grant applications in my department. Among other columns are "Application Due Date" and "Total Award Requested". I would like to be able to report on the sum of all funds applied for during a fiscal year. The AI formula creation tool produced the formula below. It looks like it should be…