IF(AND
Discussion List
- Need assistance putting all my "if conditions" into a single formula if possible
- I'd like to combine multiple IF/OR statements so when I update my status column another column will auto update: When Status is Complete or Received list Full, if not, list Empty; when Status is In Pr…
- I am working on formulas to get approvals in one of my sheets - But there are more than 2 options and I'm finding it a bit confusing… IF both directors APPROVE = Trade Off Accepted IF one director APP…
- Hi All, I am building a risks log and I am getting stuck building 'if and' statements to automate the rating. I have a drop-down column for Likelihood and a drop-down column for Impact, and based on t…
- I'm trying to put together formulas that will allow me to report forecasted labor across the months a project is active. I have all the formulas working individually but can't figure out how to group …
- I have a working formula that I'd like to add a condition to, if possible. Here is the working formula: =IF(ISERROR(MEDIAN(COLLECT({Resi - Pricing & Tools Duration}, {Resi - Enter Stage 7 Date}, AND(@…
- Hi Team - I have a bit of a doozy.. at least it is for me. I have a sheet that needs a status populated considering 2 different date columns. If either "Expiry Date" or "Expiry Date 2" is in the past …
- I am not sure how to "Nest" if functions for my application or if I need to use the "AND / OR" functions with it. Essentially, when my field team updates the [Field Status] column I want the appropria…
- Hello, I'm in the process of converting an excel spreadsheet into a smartsheet, but I've run into a problem. I'm trying to split 80% of a cost over a duration and then take a two month break before sh…
- Hi! I am a SS newbie and can't figure out what is probably a very simple formula. I am needing my Project Status to change to "Design" when the ALTA Survey Completion is checked actual and/or when the…