-
Formula Help
I am trying to write a formula that shows "Delayed" if Actual Completion Date is < today or Estimated Completion Date and show "On Time" if Actual Completion Date is => today or Estimated Completion Date. My formula is getting an unparseable message but I cannot figure out why I am getting an error. =IF(OR([Actual…
-
Formula is #UNPARSEABLE
Hello community, My formula below is showing #UNPARSEABLE. Can someone please help me figure out why? Formula: =IF([Job Complete]@row "Cancelled", "", (IFERROR(IF(ISBLANK([CIT PPO #]@row), "", IF(TODAY() > [Invoicing Status Due Date]@row, "Non Compliant", "Compliant")), "")
-
Question on using "IF", "AND", & "SUM" functions together.
I am trying to create a semi-complex formula. I have two check boxes. When someone clicks check box "A", it sums up specific columns. When someone clicks check box "B", it sums up the other columns. When someone clicks both "A" and "B" check boxes, it'll sum up all of the columns. I was able to get the individual parts…
-
Trying to share a FILTERED sheet link
How do I to share a link to a sheet that is filtered and has hidden columns to someone that does not have Smartsheet access? This is going out to the public to provide information to me and I don't want them to see what is already been shared by others. It can't be a form because they need to be able to drag repetitive…
-
Is there a way to automate new row upon receipt of email? And autopopulate basic fields?
As an example, say we tell our clients to use a template subject line: "Project Name Monthly Evidence" Could I automate the process so that the Outlook Integration captures whenever an email is received with that subject line? A new row would then be created in a sheet, pulling the basic information from the email:
-
How do I fill a date series from left to right?
I found an answer with an incredibly complicated formula for text fields, but I wanted to ask again just to be certain - is there no way to drag-fill a date series from left to right in Smartsheets? I don't want the entire column to be dates, just the one row, so you can see that Week 25 is the week of 6/19/23, for…
-
Automatically copy cell based on 2 criteria in another sheet
I am trying to take 1 cell (Term) from my "Active" sheet and I'd like it to autopopulate my Eligibility sheet with a course name, based on the Active Sheet and the Term and name selected. So Term has F/S and the course names can be 1 of 8 different courses. I'd like it to first recognize the Term (either F(all) or…
-
Incorrect Argument - Second set of eyes please
I'm not sure what I'm missing but would appreciate some help with the below formula it is giving me an incorrect argument set and I can't figure out why. =COUNTIFS({Greet}, OR(@cell = "yes", @cell = "NA"), {Week Beginning}, [Report Date]@row, {Monitor Type}, "Monitor") / COUNTIFS({Greet}, OR(@cell = "yes", @cell = "no",…
-
Count days between project start and Go Live
Hello, I am trying to create a 'countdown timer' for my dashboard to tell users how many days remain to project Go Live from whatever the date is. The current formula I am using is: =NETWORKDAYS([Start Date]1, [Due Date]1,[holidays]) and I am receiving the message #UNPARSEABLE I am uncertain what I am doing incorrectly.
-
Incorrect Argument Set with nested IF
Counting number of occurances where month/year is 1/23 AND where cell within the row does not contain "Color Add" =COUNTIFS({New Product Status (Imagen) Go Live Launch Date}, IFERROR(MONTH(@cell), 0) = 5, {New Product Status (Imagen) Go Live Launch Date}, IFERROR(YEAR(@cell), 0) = 2023, {New Product Status (Imagen) new or…