-
SUMIFS looking for specific phrase
Hi Community, I've been digging to find an answer for sometime now and haven't been able to find what I am looking for quite yet. What I need my formula to do is to search for a particular phrase and then sum the values on that same row if that phrase is found. There are four columns in which that phrase could be found,…
-
Stuck on a formula involving dates
Hello formula gods, I need your help once again. :-) I'm trying to write a formula that looks at 3 different date columns. 1. Look at the 1. actual completion date, if not blank then make it green, if it is blank then look at the revised due date column, if not blank then red for past due or yellow for reminder, if…
-
If criteria is xxx, duration is zero
Dear Smartsheet community, I have a sheet for staff to report time off. I have this formula to calculate the net working day(s) between begin date and end date. =NETWORKDAY([Begin Date]@row, [End Date]@row) However there will be occasion when staff will not be taken time off. Therefore, I want to add where column Absence…
-
Using Join/Collect to Collect from Another Sheet, Two Criteria
In Sheet 1, I want to identify the color of the title of a book that matches ISBN number, so long as the book is available in the library. Sheet 2 Available | BookTitle1 Unvailable | BookTitle2 Unvailable | BookTitle3 Available | BookTitle4 Available | BookTitle5 I want to look for a value (e.g., BookTitle__) and display…
-
Red Flag Formula
Hi All, Hoping to get some assistance with 2 questions. 1. In the Child rows, I would like the flag to go red when today's date is past the finish date AND % Complete is < 100% (ie the task is past the due date and not 100% complete). 2. The flag in the parent row (Black Circle) turns red IF any of the child row flags are…
-
Parent Function working with dates
I'm trying to report down the same date as my parent date. Of course this simple formula is not giving me the results I need. I need the parent date for each job
-
Help with Formula!
Hello, I'm pretty new to smartsheet but slowly working out how to create some functioning formulas! I wonder if anybody might be able to help me with the latest one please? I have multiple columns containing different data types (some are tick boxes, others are dates and some will say 'N/A' - I am trying to write a formula…
-
RYG Symbols from 3 Columns
I am trying to return a RYG symbol based on 3 different columns(Decision) Approved, Needs Additional Information (Denied), or Submitted. Based on these 3 columns data, if any of them say "Need Additional Information", I'd like the Symbol (Status) Column to be the Red Symbol, however if all 3 Decision Columns are "Approved"…
-
sum hours assigned to a contact on a sheet for a particular month
Example: I have a project that lasts three months on a project sheet. I am required by the client to report out how many hours of work have been completed by each person assigned to a task at the end of each month on a dashboard So for example: I need a formula that is going to Find all columns assigned to the contact…
-
VLOOKUP in Contacts Stops Halfway
I've been using the VLOOKUP function to populate contacts that I have saved in a separate sheet as my master contacts table. The names are alphabetical on both my destination and source sheets. When I drag the formula down on my destination sheet, it pulls the contacts but keeps stopping halfway at 'M,' where it says there…
