-
Can you call a sheet summary formula inside another sheet summary formula?
I have 6 sheet summary formulas. They are a sum of loads in that year over the 6 years those formulas represent. What im trying to do is calculate the percent changed year over year but it seems I cant call those formula returns into another sheet summary formula.
-
How to summarize data from multiple sheets without manually linking each cell?
Hello, I'm working on a project with KPIs that will be entered into ~50 individual sheets. I want to be able to roll-up these KPIs into one summary view, but am running into trouble when I pull them into a report because I can't perform calculations in a report. One KPI is Overtime %, so I can't just take the average of…
-
How do I change when my Sheet starts the next workday?
I have a formula in Sheet Summary that counts workdays remaining until launch. It works except that the count doesn't go down each day until 10 AM. If anyone looks at it before 10 AM, it shows an extra day. I can't figure out why it updates at 10 AM, so I don't know how to fix it. Ideally, it would change at midnight.
-
Can I access/download spreadsheets I previously made without paying for the upgrade?
I no longer have the need to use the Smartsheet service but I would like to e able to refer back to the reports, sheets, etc. that I made while using the upgraded version. Is that not possible?
-
How do I change when my Sheet starts the next workday?
I have a formula in Sheet Summary that counts workdays remaining until launch. It works except that the count doesn't go down each day until 10 AM. If anyone looks at it before 10 AM, it shows an extra day. I can't figure out why it updates at 10 AM, so I don't know how to fix it. Ideally, it would change at midnight.
-
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…