-
Using Contact List data in IF statement in Sheet Summary
I'm working on a system of sheets to track requisitions within our Talent Acquisition team. I've built out a helper sheet designed to help us track the average requisition priority ranking that each recruiter has. Since this is a helper sheet, its only purpose is to gather this metric, so I don't care what the sheet looks…
-
Summarizing a column based on another multi select column
Hello - I have a column named "Monthly Hours" that lists hours (integers). I have another column called "Site of request" that lists the site(s). That column is multi-select. I would like to summarize hours spent per site. So, if the "Monthly Hours" column has a 10, and the "Site of request" lists "Site A" and "Site B",…
-
Unable to Perform a Global Update on a Sheet Summary Field
I am trying to replace a formula in a Sheet Summary Field and it doesn't do anything regardless of what I choose. After adding Advanced Criteria [ROW] Is Profile Data doesn't seem to do anything. It appears I am missing something or it is not working?
-
Map for Location Data
Hi, Is there any map feature that Smartsheet provides (or third party) to show on a map data of a location-column on a Smartsheet? Thank you!
-
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…