-
Tips for Showing Count of Answers Completed on a Smartsheet?
If I have a section with three rows underneath my heading, I'm able to easily use a formula to show the count of tasks completed/responded to out of my total number: ="Introduction: " + COUNT(Response4:Response6) + " of " + COUNT(CHILDREN()) However, if I have a section with multiple sub-sections, I'm struggling to use aโฆ
-
Get values in card header display or get total items of a type without countif for each?
When viewing by a category in card view (think color), it places the number of items in that column in parenthesis next to the column title. All of the "blue" items are in the column and the column header is "Blue (22)", the next would be "Red (12)" and so on. Is it possible to get that number for use in a dashboard (and aโฆ
-
time analysis via modified columns for automated alerts
I'm trying to find a pattern as to how the numbers are generated when two modified by cells are subtracted from each other. At first I thought it was in minutes and separated via location in the number, but upon testing that proved to be incorrect. Does anyone know how to translate the number that is given when twoโฆ
-
CountIF incorrect
Im trying to count the number of total number of "Open" "Risks" in another sheet =COUNTIFS({RAID Log Range 1}, "Risk") + (COUNTIFS({RAID Log Range 2}, "Open")) I only have 1 open risk but its returningย 5. This is because its counting the total number of "open" AND "Risks"ย into my count. How do I write the formula to beโฆ
-
Automatically marking something as complete when requirements are filled
Hello, I was wondering if someone would be able to help me with a problem that I have been struggling with. I would like to make it so that when a checkbox is checked, in another column, called status, that it would switch and say complete. The status column is a Dropbox, containing Completed, In-progress and Not started.โฆ
-
Zapier sends string, but Smartsheet processes as an integer
We use a unique number sequence by combining two integers for each row sent to Smartsheet. I worked with Zapier to verify that the integers are sent to Smartsheet as a string, not a number. What I am seeing is if the string is not long enough, Smartsheet converts the information toย a number and our formulas do notโฆ
-
VLookup #No Match Error
I am looking for guidance for the utilization of the VLookup formula. I have formatted this formula within one of my Smartsheet sheets and I keep getting the #No Match error message, I have verified this information already: 1) Range to retrieve data from is 3 columns wide by about 1000 lines long, so I don't believe thatโฆ
-
SUMIF formula is making me crazy.
Just when I think I am getting better with formulas I hit a wall with something that seems simple. I need to add 2 column sums together for the rows that have a RED ball Status. =SUMIF(Status:Status, "Red", [Repair Inv. Amount]:[Repair Inv. Amount] + [Diagnostic Inv. Amount]:[Diagnostic Inv. Amount]) Then I get an invalidโฆ
-
Display a counter in a bar graph
Hi community, I'm making a bar graph which shows information in %, so each barย isย the percentage of the information I want to show, but this '%' comes from a scalar number which I also want to display. Is there a way to do this? I attach an example.
-
Index Match with 2 sheets
Hi, I have successfullyย setup an index/match with 1 sheet but I need to add a 2nd sheet for the index to search as well. How would I set this up in the formula? I tried to notate both sheet's columns for the range but keep getting an error. Thanks