-
Excluding two values for Sheet Summary Formula
Hi all, I was wondering whether you might be able to help. I have a column "Status" and I would like to write a formula for a sheet summary field that counts the number of status' that are anything other than "On Hold" and "Complete". I've tried various COUNTIFs but none seem to be working! Any help on this would be great!…
-
Sheet Summary CountIFS + Date Range
Hi All, Need some assistance. Found a great post & this on the subject but was not able to get my formulas to work. Hoping the group can help. I have 1 working the other is not. Background: Form was converted over from Google Form/Sheets & several formatting changes had to be made in August. (Probably issue #1) Co-workers…
-
COUNTM for 2 Ranges
Hi, How can I count a total of values, in 2 diferent columns that are in 2 deiferent sheets? I need something like this.. =COUNTM({Range 1} AND({Range 2}) Thank you!
-
Can't edit Sheet Summary fields
I've copied sheets with Sheet Summaries to other sheets. I used to be able to then edit the Sheet Summaries but no longer. My only option now is to delete. Any thoughts?
-
Show next pending task in Summary
Hello, I am trying to show the next pending (open) task in Summary, so it will show on my Summary report as well. In the summary report I also want to show the delivery date for that task. Basically if the previous task is Completed (checked), then I want the next one to show in Summary. I am trying an IF and VLOOKUP…
-
Summary Field, Date Within Range using SUMIFS
Hi, I am trying to use the following SUMIFS formula but I receive a "#INVALID OPERATION" error when trying to create a Sheet Summary Field using the formula. =SUMIFS(Hours:Hours, Status:Status, "Confirmed", FinishDate:FinishDate, >=12/10/2021) However, if I remove the ">=" and just use the date 12/10/2021 I do not get the…
-
Last update Formula (Sheet Summary)
I need to make a formula that identifies the last modified date on my sheet
-
How do I correctly use Sum & Value formulas together?
I'm trying to get the total monthly parking charges for my office. I have a column showing each individual's monthly parking charges, if applicable (enabled or disabled). For the sheet summary, using =sum([Monthly Cost]1:[Monthly Cost]84) doesn't return anything but 0 because the column is using text. I've tried adding the…
-
Summary Data for a report
I have two sheets that have a lot of data on them, and I am using a Summary report to find out the % of task done on one of those sheets. How can I then pull the data from both of them into one report to see all the data I need to see? Example: One sheet has client name, contact information etc... The other sheet has…
-
Add Two Summary Fields To A Cell
Hello and thank you in advance for any help you might be able to offer. I'm just getting going in smartsheet. I've built my first sheet with Summary Fields (brief pause while I pat myself on the back). I'd like to take those summary fields and auto-fill cells in the sheet. I've figured out how to do it with one summary.…
