-
I am trying to count a cross reference including 2 columns using @row in my metric sheet :<
So if Category = x and Status is = "Closed" , then I will add formula in pending column etc.... I am having to build multiple sheets to gather data from multiple source reports, then combine that data on one sheet to build a report and roll up to Dashboard :< Please help, I keep getting either the wrong total or…
-
IF/AND Statement
Hello, I am trying to write a formula where a box will be checked if a date listed is older than 10 days, AND if the status in another column is listed as "UNAPPROVED." I got the date part down already, but I'm having trouble adding in the second expression. Anyone have any ideas? This is what I have now:…
-
Counting rows based on time created
I am looking to build a report based to count the no of rows created between a certain time, say 0800-20:00 for today with one condition. Tried all possible combination but no luck. Any help please?
-
COUNTIF and AND
Hi there, I am looking to add up all customer, that have either a "no" or are blank. I excluded yes (see below), but it does not count the blank ones, only the "no". =COUNTIF([Ambient device in scope?]:[Ambient device in scope?], <>"yes") What may I be doing wrong? If I need to write a formula, which counts all the ''no"…
-
COUNTIFS
Hi @Paul Newcome ! I hope you're doing well. I need help with a COUNTIFS Formula. I am trying to plug multiple criteria in an COUNTIFS statement but I'm just getting the value "0" and not the right value. The formula that I am using is: =COUNTIFS(Status:Status, "Requested", Status:Status, "Demoed", [Automation…
-
If Error Added to ROI Formula
Smartsheet Community: I tried to add IFError to the Formula below to Return Blank in the Event I have 0.00 Investment (Investment $$ Column) Original Formula: =([Gain Or Loss]@row - [Investment $$]@row) / [Investment $$]@row Thanks
-
Controlling Traffic Light Symbols Based on Comparison and Date Fields
Hello everyone, I am attempting to control the "traffic light" symbols, Green, Yellow, Red, based on a comparison of one field to another and a date range. Essentially it's a booking system where user inputs X and requests a date range. I'm trying to make it possible to book into the future and make my status symbol change…
-
Can I add time windows to reports when scheduling with Smartsheet
I'm using Smartsheet to schedule my service department. I'm able to sort by date but there are occasions where I have multiple calls for one individual in a single day. I'm trying set it up where the calls will be sorted by time windows so that I don't have to rely on my guys reading the notes, which they rarely do. Is…
-
Compare a Field if Column Can Contain Same Value More Than Once.
Hi All, I'm creating a booking system and think I am running into trouble with my formula because it's possible to assign the same value in a column more than once (so the formula doesn't know which row to look at possibly). Formula below. =IF(AND({DateCheckFlag}@row=1,[Asset Name]@row={DeviceName}@row),1,0) In my case, I…
-
vlookup adding data to a field with existing data?
If my spreadsheet has a notes column and notes are in the field. Then I use a form to collect information and notes via another spreadsheet. Once I pull the information from the second spreadsheet over to the first one, will the notes from the second spreadsheet be added to the notes on the first spreadsheet or will they…
