-
How do I extract dateonly from system generated date columns?
Hello, I would like to create conditional formatting based on a system-generated date being more than 7 days in the past (my test is if it's less than 6, then trigger the flag). I created a helper column to do the math, upon which the conditional formatting is supposed to be set (if the flag is activated, then turn…
-
nested if formatting
Hi, Could you please share a proper format of a nested if statement? getting UNPARSEABLE error: =IF([% Complete]@row <= 0.7, "Red", IF([% Complete]@row > 0.7, AND,[% Complete]@row < 1,"Yellow"),IF[% Complete]@row = 1,"Green))) Thank you
-
Countif with OR?
Hi All, We have a department where the Project Managers can be assigned as the design PM and/or the construction PM. Please see the example below: In this snapshot, I filtered the view to where D-PM is one of M. Johnson or C-PM is one of M. Johnson. In the D-PM column he is listed 3 times and the C-PM column he is listed 5…
-
How to use Form response to retrieve the right template?
I have 7 templates for client renewal. I want to create a workflow either with a form or formulas, the user will select the right template for the client renewal and automatically added to the Master Client Renewal Project Plan. Example 1 - Client Renewal - Template A Example 2 - Client Renewal - Template B Example 3 -…
-
Count number of registrants from each company
I feel like I'm missing an obvious function here. I'm using smartsheet to register attendees for a virtual event. I'd like to add a chart on my dashboard that shows the number of registrants from each company. I know how to do a count if function but I don't want to do one for each of the dozens of companies we have…
-
Green, Yellow, Red Blue Formatting
Hello, Newbie here. Trying to set some formatting for some specific RYGB and I can only get it to work for Yellow. Any thoughts? I receive the #INCORRECT ARGUMENT error. Thanks in advance! =IF([Completed%]2 = 1, "Green", IF(AND(Today1 > Start2, Today1 < Finish2, [Completed%]2 = 0), "Yellow", IF(Start2 > $Today$1,…
-
Can IF, Contains and VLOOKUP be combined?
Hi all, I am trying to combine IF and CONTAINS with VLOOKUP (refer following) but it is throwing #INCORRECT ARGUMENT =IF(CONTAINS("1", {Count}, VLOOKUP("TD", {Mastersheetrng}, 2))) Can these be combined, or some other combination will work, please help. Prajna
-
Is there a formula or shortcut to change text to Proper case?
I have a very large sheet where some of the text was written in upper case. I know the UPPER and LOWER functions will change the entire sentence to lowercase, but is there a PROPER function (like in excel) to capitalize the first letter of the sentence with the subsequent letters in lower case?
-
Combining IF Formula - Is This Possible?
Hello, I'm working on a formula that will trigger a status of "complete" based on a Task Reviewed column. =IF([Task Reviewed]5883 = 1, "Complete", PARENT()) I am trying to combine the formula with another one that will trigger the same status as the parent row when the cell above it is complete. =IF(Status5882 =…
-
How to display results from original smartsheet in another smartsheet to create a dashboard
Hello! I am creating an executive summary dashboard for people external to our company. I have a data source smartsheet (primary) that has a lot more detail that I do not want to give them access to. I would like to create a smartsheet that references specific information from the primary smartsheet, but shows the details,…
