-
Need to count number of days
I need to count the number of days from today to a certain date in a column. =TODAY() - IF([Assigned Date]@row <> "", [Assigned Date]@row, "0") This is what I have, I want it to display the zero if there is no date in the assigned date column. I get invalid operation when there is not a date. Thank you for your help. Ali
-
Today's Date Formula
Hello! Is there a formula I can use in Smart sheet that will give me Today's date? Ideally I want to have the cell change to whatever "today's" date is in order to create a separate formula that calculates days until a certain deadline. Thank you!
-
Workaround to override column formula for dates?
Hi there, I have a sheet with 8,000 rows. In the sheet, each row has a task, task start date and task end date. When someone adds a start date to the first task, the rest of the dates are calculated with a formula, based on a lookup table that has values for how long each task takes. If I have 10 tasks, I want the formula…
-
Lookup a row and count all the "Yes" values across multiple columns
I can do both of these functions separately without issue, but am struggling to combine them. I have 2 sheets and would like to lookup a value from the 1st sheet on the 2nd sheet, and then return all the "yes" fields on that row from a set of 8 columns. I can use match to lookup the value from the 1st sheet and find it in…
-
Issue with VLOOKUP
I input a vlookup formula on my Smartsheet, and some of the values are not returning a match even though they are a valid option from my reference list. Below is the formula I'm using in my sheet. Here is the data table I'm referencing for the values. As you can see, the bottom two values are included in my reference, but…
-
Is there a Way to Emulate SUMPRODUCT In Smartsheet With a Cross Sheet Reference?
Hi all! I am trying to create a SUMPRODUCT in Smartsheet, however when I do I receive the "INVALID OPERATION" error. This is how I was trying to go about it; I created a helper column where I would multiply both A x B, then I was simply going to sum up all the products. The issue I'm encountering is with the first part. I…
-
I can't delete cross sheet references
Does anyone what I am doing wrong? I have reached my limit of cross-sheet references on a sheet. I can open "Manage References" and filter down to unused references. I can delete the references here and it looks like they are gone, but I can not make a new cross-sheet reference and when I save and refresh the page, the…
-
Countifs to Find Duplicates
I am trying to find if there are multiple requests for a bucket truck within a single day. I am getting an incorrect argument set when I try this formula, but I cannot figure out what is wrong with it. =COUNTIFS([Date Resource(s) Needed]:[Date Resource(s) Needed], [Date Resource(s) Needed]@row, [Bucket Type]@row, "55'…
-
Formula Help
Hi, I have this formula that pulls from the values below (see screenshot) but the formula says #NO MATCH when no stage is started, then again once all stages are complete. Can someone help me with a formula that will give another value other than #NO MATCH. It should say "New Project" before the stages start and "Project…
-
Formula for Scoring a Project (with Weights)
Hello! I am looking to give my projects a score, based on 8 different options. In one column I have a multi-select to pick from those 8 criteria and then I want to have a column to give a numerical score for the project based on how many of the 8 criteria are selected. One problem is I want to make two of the criteria…