-
Adding Multiple Criteria + Does Not Include
Hello, Smartsheet community! I am stumped on a function. I have attached a photo of a dummy sheet with the same functionality I am trying to achieve. Using the example, how would I set up a formula which adds together the lunch selections of turkey, ham, and roast beef if they DID NOT choose soda as their drink? Lunch…
-
Project Sheet - Static Finish Date
I didn't see a post about this yet, please post a link if this is a repeat issue! It seems like the default relationship between Duration, Start, and Finish is that when you update the finish date or the duration, the start date is kept static, the duration gets extended and the finish date gets pushed out. Is there a way…
-
Look up multiple column values from Sheet B to match values in Sheet A to return value from Sheet B
Hello, I'm trying to make a formula that counts values from Sheet A against multiple columns in Sheet B, if only 1 total match is found, then lookup values from Sheet A against Sheet B and based on the result, pull in the value from a Status column. If either too many same results or no results are found return a text…
-
Please assist with this formula. Thanks.
All data is in a single sheet. I need all rows in a column titled "Status" to be populated with "APPROVED" when the following conditions are met: "Yes" in column titled "BU Approval", "Green" or "Yellow" in column titled "B", "Accepted" or "N/A" in column titled "C", date in column titled "D" is today or in future, Box in…
-
MIN DATE with Conditions
Hello. I'd like to return the minimum (and maximum) date from another sheet with multiple conditions. Detailed Sheet: Rollup Sheet I would like to populate the earliest Start and latest End Date in the Rollup sheet from the detailed sheet where the Request Owner is equal to request owner in rollup sheet and the status is…
-
Flexible Duration value when calculating scheduling dates
I have a Smartsheet which is a project plan with the Dependencies and Duration columns is being used in scheduling calculations to automatically deriving the start/end dates for each task. However, I need the Duration to be dynamic e.g. linking cell to a cell in another sheet or to contain a formulae.. However, I cannot…
-
How to get JOIN working when referencing another sheet?
I'm using the JOIN formula, if I put the formula on the same sheet as my column references, it works just fine, however when I move this to a separate sheet and update the column references to the other sheet I get the error #UNPARSEABLE. I haven't removed any of the formula delimiters only which sheet I'm referencing. Any…
-
Searching a text in a string
I'm looking for a string "College 1" in a text and update Subcategory column with the text found. A helper column "College?" let me know that "Task Name" has "College" in Task Name. "College 1" can be anywhere in the string Please assist as my formula is not working. Thanks in advance.
-
Drop down on dashboard pull all matching rows
I am trying to build a dashboard that will allow someone to enter a Asset# and it will pull all rows from a sheet that match that Asset#. The Primary Column is a Inspection number that contains the asset# and date. There is a separate column that is the Asset#. It would be even better if it would show it from youngest to…
-
I need help writing a formula.
Logic if cell b >0, then calculate the Sum Cell b-cell a