-
Can Pivot Sheets shared or embeded in iFrame?
Just try the Pivot Sheet in the smart sheet, that is the something I am looking for. But whether it can be shared or embed in wiki. Which I don't need to export the result and do the analysis in the excel?
-
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"…
-
Formula for a future meeting date (after today)
Good morning - I have a series of columns with scheduled "future" meeting dates. I want to populate one column with the date of the next scheduled meeting. Have tried importing the formula which works in Excel over, but Smartsheet keeps on saying "INVALIDOPERATION. Help please !