-
Most Occurring Value Based on Multiple Criteria
Our organization is counting how often we interact with clients weekly and that process is going great. What I want to do is show who contacted the most clients during a particular week. We have a data dump master sheet and a sheet where I consolidate some high level data. With this one I don't even know where to start…
-
#INVALID OPERATION is trying to break me
This formula is wrecking my day so I am waving the white flag and asking for help... I am attempting to display the LOG 2 "Title Company" where the LOG 1 FC Start Date (020) .GT/ET. the LOG 2 "Effective Date" and LOG 1 FC Start Date (020) .LT/ET. the LOG 2 "End Date" and LOG 1 "Property State" = LOG 2 "Property State".…
-
Change Past Date into Month as Written Text
Probably a simply question but I'm looking for a formula that is able to read dates in the past, and then fill a different cell with the month as text only. e.g. The first 'offline' date would populate the offline month with 'October' Thanks
-
Changing State Based on Criteria.
Hi all, I think I have some syntax incorrect in my code and hoping for some help. Currently, I have a formula that sets the State of a task based on % Complete: "=IF([% Complete]@row = 0, "Not Started", IF(AND([% Complete]@row > 0, [% Complete]@row < 1), "In Progress", IF([% Complete]@row = 1, "Complete")))" I also have an…
-
RYG Status Balls Formula Help!!
I am looking for help developing a formula for the following RYG Status Balls Conditions: If status is "not started", grey If it is 1 day before "due date" and status is NOT "complete", yellow If it is the day of the "due date" or past "due date", red If status is "complete", or "in progress" and it is 2 days or more away…
-
Nested if /or formula
Hello, I am looking to have a status bar (the one with empty, half, three quarter and full) look at two columns and give a result. I have percent complete and a "Done" checkbox. the percent complete is by date, so when the date gets closer the status bar shows progress. Here is the formula I am using to do so..…
-
Max Function but with Text
Hello Smartsheet Community: I want the Overall column to look at Issue A, Issue B, Issue C and Issue D and return the highest level. The levels are No Deficiencies, Low, Medium and High. Is that possible with text? See screen shot. I know I can do this if I made High = 3, Medium = 2, etc. and only had numeric values in the…
-
COUNTIFS functionality for multiple entries
New to SmartSheet and I promise I have been looking around for an answer, but without any luck so I thought I would throw it out to the community... I am looking to sum up all entries in column in a summary total at the top of my sheet, but the formula I have is only calculating where the searched for text is alone in the…
-
Unparseable Error
Good morning, I'm new to Smartsheet. I'm getting an error when I add the following formula. I'm trying to get it to return the current project phase that is less than 100%. Do you know what I'm doing wrong? =IF([% Complete]37<100%,[Task Name]37, [% Complete]54<100%,[Task Name]54, [% Complete]75<100%, [Task Name]75, [%…
-
MAX and COLLECT to return most recent value not the highest
Hello! I am currently trying (and failing) to create a cross-sheet formula that will look for the most recent date for a given lot and then return a specific value from that date. Sounds simple enough right? I have one column on my metrics sheet that correctly pulls the most recent date for a given lot: =MAX(COLLECT({Assay…