-
Help with If ISBLANK or statement
I'd like a column to populate "late" based on whether another column has a date in it or is blank. Does anyone have any experience with nesting this type of formula?
-
Adding Nested IF Statement to Formula
I have a formula that calculates the "Planned % Complete" based on start and end date, with no weighting. We use it as a general guide because there is no planned % complete provided by Smartsheet. Formula: =IF(Start14 >= TODAY(), 0, IF(Finish14<= TODAY(), 1, (NETWORKDAY(Start14, MIN(TODAY(), Finish14)) /…
-
Formula for calculating years accurately
We need a formula for calculating years accurately when we compare a date with the date today – some examples would be: * Age in years: Today() - date of birth, currently we use: =(TODAY() – DOB1) / 365.25 but it doesn’t always give the correct answer. The 365.25 is days in a year allowing for leap years, or * Length of…
-
Newbie: trying to return cell contents if date is less than and greater than...
I'm new at this. Let's say these are my three columns: Open Balance | AR Due Date | WK 1 So in the WK1 cell I want this formula: If the AR Due Date is greater than 01/01/2018 and less than 01/07/2018, then return the value of Open Balance. I've tried, but keep getting errors. Thanks for your help.
-
Formula for SUM by the category
Unfortunately couldn't find the solution here. I'm just looking for a formula that will allow me to count total sum by the category of a product. Basically, I have two columns: first is the Dropdown list with the category of a product, and second one is the Text/number column with the bid amount. What I need is a total sum…
-
linking two columns togther
Hello Everyone, I have two columns, one has the name of the customer "name" and the other column has the number we assigned to the customer "number". I am trying to link these two for example, let us say if I type 111 in the number column the name joe will appear in the name column, and the other way around. If I write joe…
-
Locking rows already saved.
Is possible to locking some cells in a row after a collaborator saved? The collaborator will enter information in all cells in a row (this is why cannot be locked before been saved). After saving the information entered, some cells cannot be edit anymore but other cells can be add a value or edit. Thanks. Al
-
Formula to change RYGG balls when Project Stage changes
I am new to SS and I am trying to automate the Project Status Red, Yellow, Green & Gray balls to change to the correct color based on the Project Stage selected. Project Stage drop down will need to work as follows: Red Ball = Not Started Yellow Ball = Scheduled, Field Work, Drafting, Completed, Preliminary Sent Gray Ball…
-
Item Tracking
I am building an item tracking report with a helper column. There are 14 different items, and I want the helper column to post 1 (or anything it honestly doesn't matter what it posts) if it is the most recent action for an item for the purpose of building a report. I've got an autocreated time column and autocreated index…
-
automatic notifications when dates are passed
We created a new sheet for tracking our work and have a cell with a due date for design submittals. There is an empty cell next to the due date that we want the user to add either a check box or date to show the submittal was actually done. The question is, if the date or checkbox isn't filled out after the due date has…
