-
How do I turn off the pop-up messages while editing a formula in Summary fields?
These pop-ups block what I am editing. If I close one, then click to edit, another pops up - over and over. If I stretch my screen, they will pop up on the side - but then popup over what I am editing. I have to move re-stretch my window EVERY time I try to edit a Summary field..
-
Formula not working
Can someone please help me with this formula? I've worked on it since 7:30 am it's now 10:15 am. =COUNTIFS({complaints Range 1}, NOT(ISBLANK(@row)), {complaints Range 2}, >=DATE(2023, 1, 1), {File a complaint Range 3}, <=DATE(2023, 12, 31))
-
Editable Sheet Summary Report
It would be a good addition to Smartsheet to be able to edit data in Sheet Summary reports, just like we can edit regular Row Reports. I don't understand why the 'two-way' data entry functionality between Sheets and Reports does not apply to Sheet Summary fields.
-
Count Columns in data sheet to appear in calc sheet.
I need help writing a Smartsheet formula that examines the "status" and "County if known" columns in a data spreadsheet. I want it to count the number of each type of status for each county. The Smartsheet containing the data is named "Test of File a complaint" the sheet where the calculation will appear is named…
-
Count # of Parent Rows in a Sheet
This seems like such an elementary question but I keep going around and around on this and I can't find what I'm doing wrong. I'm trying to count the number of parent rows in the sheet (each parent row represents an "Employee Name"); I want to include this count in the sheet summary but I can't seem to figure it out. This…
-
Sheet summary formula becomes #unparseable upon sheet exit
Hey folks, I'm hoping you can help me solve a mystery. I have about 30 sheet summary fields all using the same formula, which counts two types of responses in each column. I copied and pasted the basic formula in every sheet summary field, then changed to the appropriate column name (the column names are spelled…
-
If bringing numbers into Sheet Summary by a formula - need to be able to make less then 0 Red
If using a formula to get Sheet Summary data - for numbers, need to be able to make less then 0 Red
-
Using formulas to populate the sheet summary, would like negative number to be red
Is there anyway in the sheet summary to have a negative number coming in by a formula to be red?
-
REMOVE IF SLOT IS TAKE
Hello! Can we remove a time slot in the drop down on a specific date if it is taken. Below is an example. For example if someone Booked - Dec. 31, 2023 - 9:00AM - 9:20AM, can we automatically remove that from the drop down list since someone booked it? What are the ways?
-
How To create a revenue summary formula
How can I create a formula where by I have rows containing different projects, their value and the dates they will start and end and create a summary to show in what months will generate what value (assuming the value is divided equally over however many months the project spans) i.e. Row 1 is Project X with a value of…