-
Contact List Dropdown - Adding multiple contacts to the list at once
Is there a way to import contacts into a contact list column in a specific sheet? I know you can import a list of contacts to the SS account but I have 2,000+ contacts that need to be added as a dropdown in a specific sheet (a contact list column). I'm assuming there is no direct way to import the list into that specific…
-
Workday Function Counting Holidays on Another Sheet
Trying to make a function where it counts holidays referenced on another sheet. The formula I am using is =WORKDAY([Test Out Date]@row, 30, {Reference Sheet Column Location}) and I am getting an "Invalid Data Type" error Any idea what I need to do? I dont want to include my holidays on the same sheet cause it messes up…
-
How can I use the Index function to find the last specific values in a column?
Here is the formula I started with: =IF([Hide Level 1]37 = "N", "", IF(INDEX(Format$1:Format36, COUNT(Format$1:Format36) + 0) = "W", "B", IF(INDEX(Format$1:Format36, COUNT(Format$1:Format36) + 0) = "B", "W"))) I am trying to index the Format column to find the last "B" or "W" so the formula will result in a "W" if the…
-
Status related to % Complete
I am trying to accomplish the following formula: 100% status turns green 1%-99% status turns yellow 0%= Gray work paused = red Is this possible with red?
-
"Not Equal To" Help
I have the below formula that works with the exception of the OR function. It is not omitting blank cells or cells that contain "Vacant" in the Emp No in its count. =COUNTIFS({Route}, $[Primary Column]@row, {Landside Storm helper}, 0, {Operations Report Range 1}, <>1, {Day/Night}, [Storm Type Contact]@row, {Emp No},…
-
How to combine two IF formulas into one formula
Hey Smartsheet Community, I was able to get the info I wanted using three different formulas but I wanted to know if it was possible to make this work with one big formula? Formula 1 - Symbol Colors for Major Project Completion Status =IF(AND([*Dropdown-Single*]17 = "Major Project", [*Date*]6 < TODAY(-30), [*Text*]55 <…
-
Formula to return a date that always lands on Wednesday
Hi, I'm trying to create a formula that takes a date and returns a date that is the following Wednesday. So it is always a date that starts on a Wednesday. This is the formula I've tried, but it's not working. =IF(WEEKDAY([Task Name]29)<=4,(4-WEEKDAY([Task Name]29))+([Task Name]29),(11-WEEKDAY([Task Name]29))+([Task…
-
How to display Name of the user who created record?
Created By displays email. How can I display the actual Name of the user who submitted record through form?
-
Automating a Roll up for RYG Symbols for Health
Team, Thank you for your patience, I'm still learning. I have gone down a rabbit hole trying to figure out how to roll up Health symbols RGY. In my search for help I came across this formula but it's not working. =IF(COUNTIFS(CHILDREN(), "Red") > 1, "Red", IF(COUNTIFS(CHILDREN(), "Red") > 0, "Yellow",…
-
Another Nested IF Formula
Could use your help again. Not sure why I have so much trouble with these nested IF statements but I do! When I use the formula below and the Business Unit is equal to EMEA, it returns ASD....any ideas? =IF([Business Unit]@row = "Biologics", "ASD", IF([Business Unit]@row = "Western", "ASD", IF([Business Unit]@row = "Simple…