-
Formula to calculate project number based on group
Hi I want to calculate a project number based on what group it is in. In this example, there are 16 projects among 4 departments. I entered the 3rd column manually; i.e. the first digit is the department number and the second digit is the nth project for that department. What formula can I use to calculate the values in…
-
Smartsheet Forms - Apostrophe automatically added to formula
Hi All, I've just started creating a Smartsheet form for people to easily add data however one cell should just be a formula so I'm using the 'Default Value' under field options but when the form is submitted an apostrophe is automatically added to the front of the formula rendering it useless without editing it. I've…
-
Formula is not copying
Hi, I am having a problem with one formula that is not automatically copying to a new row (there are others that are being copied). The formula is: =JOIN(CHILDREN([Column Name]1, ", ") Why every other formula is being copied but not this? Thanks.
-
Convert numbers to text & concatenate
Hi all, I'm new to Smartsheets and hit a bit of a wall. I need to put task due dates in a 30-60-90 designation. That 30-60-90 is set one time at the beginning of the month so it's not dynamic. I thought my best bet would be to build a column designated YYYYMM to do any month math for the rough 30-60-90 column. I figured…
-
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…