-
Cumulative record of live sheet summary reports
Hi everyone, I have a sheet summary set up on every project, which tracks a number of weekly KPIs - e.g total tasks that week, total completed that week etc. The sheet summaries feed into a larger sheet summary report which shows these KPIs, but only for this week. I'd like to capture the info in the sheet summary report…
-
Hi, what is the best formula to collect a text in a range of column and return it into main column?
-
Summary Field return symbol for most recent entry
Hi, I've been searching and testing without much luck. I have a task list that the project health is updated with each task. I added a column for last modified date. I would like to have the summary field reflect the health on the row where the most recent modified date is. This summary field will be collected in a summary…
-
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))