-
Date formula in content calendar template
I'm trying to copy the content calendar template into the rest of the months for this year. It has January filled out but the rest are blank. I'd like to have the week column updated to the correct dates for each week in the month. I can't seem to figure out the formula to correct the issue (you can see below the date is…
-
Multiple IF statements (or similar) to drive RYGB
I am trying to write a formula that returns a Red/Yellow/Green based on 4 part. I've searched the community but nothing has helped so far. I've tried IF AND and IF INDEX formulas but I'm clearly getting something wrong in the logic or expression usage. UNPARSEABLE is my constant friend... The example is for a project and I…
-
Combining Formulas to make one big Formula
I currently have all the individuals formulas i'm looking for however I'm having trouble combining them into one formula that I can embed in a cell. I know I can create a workflow automation to get the result I want however I enjoy the rapidness of using an embedded formula. Does anyone know if it's possible to combine the…
-
Sum if row contains
Hey All! i am looking for help with a formula i want to sum all "Actual Time Spent" in the top section "Monthly Expectation" based on the total entered below in "Record of tasks" So in Monthly Expectations the "Client Requests" would show a total of .75 based on what was recorded below
-
How to compar two fields that have multiple options, any match = true
Example of my issue, Looking for match, from these two multi select fields. Field A, options are apple, orange, lemon, lime Field B, options are apple, orange, lemon, lime Field C. If match found = 1 User selects options apple, orange, lemon from Field A. User selects options apple, lemon from Field B. I want Field C to…
-
If Statements when comparing numbers
Hi all, I am working with a colleague to create formulas and I am stumped on this one. We've done a lot of logic on it and can only get two to work at any given time. He needs to make it so if the Pending Days Overall vs Days before Go Live is used to determine if a project is Ahead, On Track, At Risk, or Delayed. If there…
-
Conditional Math Difference
Great Morning, I would like to create a condition to apply a basic math difference to identify savings in a project. Ex: Original Budget minus (if there is a value on the estimate column only, and not actual expenses yet, deduct the estimate amount BUT if the actual expense column has a value different than $0, use this…
-
How can I have cell C contents change if cell A changes?
Hey there all, I don't know exactly how to word my question - but I have 3 rows attached to contacts lists in the SmartSheet. Contact List A, B, and C. See below, for column C as individual's are added to this sheet, we will also add their Coach in column A. But coaches can change with tenure, so what I want to do is take…
-
Can I make a form demand EITHER field be required?
Hullo: I am using a form to track outside vendor shipments. Sometimes our shipping team gets stuff into the system in advance, sometimes after it's been picked up. I would like a form that requires either Estimated Ship or Actual Ship. If one is filled, the other doesn't need to be, but at least *one* of them must be…
-
Row ID
Can someone confirm for me if the Row ID of a row changes when I MOVE a row to another sheet? I assume it does change if I copy the row, but I am unsure about when it's a move. Thanks!
