-
Networkdays with If
I am trying to run the networkdays formula based off a certain status. So what I am trying to accomplish is if the position status shows filled, how long did it take to fill? Here is the formula I am trying and I get the Unparseable error. =IF([Position Status]@row='Filled',NETWORKDAYS([Submitted to HM]@row, [Overallโฆ
-
User Account setting for Automation Workflow
Hi, I have set up a number of automation workflow in Smartsheet which will generate emails under different conditions, e.g. Update Request. Due to job rotations, my role will change and will no longer work for my current group. As my Smartsheet account together with my company email for creating this Smartsheer accountโฆ
-
Automation workflow in task tracking sheet
Hi, I have set up a number of automated workflow in Smartsheet which will generate emails under different conditions, e.g. update request. For these generated emails, I found that my name is shown as the sender. It 's be shown as, for example: " (My name) via Smartsheet" Is there's a way to change this setting to hide myโฆ
-
Odd vlookup behavior
Hello, I have configured two columns in a sheet with a vlookup column formula. The formula references another sheet in the same workspace and initially works fine. When a new row is added via a form, the two columns show a #nomatch error. I verified the key and the data I'm looking for exists in the reference table so I'mโฆ
-
Large criterion name
Hello, I'm trying to make a formula to count the number of jobs by builder for the month of January to go into my sheet summary. I managed to get the formula working for January however when i copied and pasted the formula and changed the name of the builder i got #invalid operation. The working formula is as follows,โฆ
-
Linking from cell in another worksheet
Hi, I have a workspace consists of multiple worksheets. So far all the sheets' primary columns were exactly the same as they are all linked to one master sheet. Same Site Ids, all unique of course, same amount of rows,etc. For this particular example below, it appears that I need to add another PO#, but this PO number willโฆ
-
checked box after 3 cells have been filled.
I am trying to figure out a formula to have a box checked once 3 dates have been entered, please help me! Thank you :)
-
Cross-sheet References in Formulas Generating #REF Errors
This formula has been working for years, with no changes to the underlying structure. Any ideas? I see that this eventually resolved itself for other users, but it's been a couple weeks for me.
-
Formula for counting registration types
Hello, I have a registration sheet and I'm trying to calculate the total number of in-person registrants we have and other registration types. What formula should I use for this?
-
Turn Flag Red if Due Date is Past Today
I am trying to turn my flag column red if my due date is past today. I am using =IF(AND(Due Date]@row < +1<> "Complete"), 1, 0) I am adding the formula to my Due Now column and getting Unparseable. Please help! :)