-
Adding months to a cell linked date
Hi everyone, I am trying to add 3 months and 6 months on from a date that comes from another sheet. =DATE(YEAR([Date (Hidden)]5), MONTH([Date (Hidden)]5) + 6, DAY([Date (Hidden)]5)) That is the formula I am using. As long as it is in the same year this formula works but if the it goes into the next year the formula becomes…
-
Dashboard with date range parameter but allow multiple users to view their own dashboard with differ
Hello. I made a Smartsheet dashboard which allows them to select a "From" date and a "To" date and allow a user to view the dashboard within that time frame. However, I am wondering if there's a way for more than one user to view this dashboard with their own date range without bothering others' date range when they view…
-
Formula for Milestone Health
I'm trying to figure out a formula for "Site Health". Each site has 9 milestones that will have a "Milestone Health" column. Each milestone must be completed a certain number of days before the project end date (October 31-22). I don't know how to create a formula to make the milestone health Green, Yellow and Red. At the…
-
Collect with criteria across multiple sheets
I have a function, created by contractor, that I'm confused about. Basically it's just a collect, but the criteria is referencing multiple sheets. Is this a valid practice? Also, for some reason it's returning Incorrect Argument Set, even with the IFERROR. Thanks,
-
How to use the collect formula on a date range?
Hey! I've been trying to figure out how to return a value from another sheet if a date falls within a range. I thought I had the formula figured out but it's not working 100% of the time, so I was wondering if anyone had suggestions on what to do? To start, I'll explain the goal. I need to have a "Y" value populated in a…
-
Progress Bar Formula
Hello! I am trying to create a formula for the progress bar which will change according to the state and % complete. The following formula is what I have come up with but it doesn't not seem to be working. Is IF/And required here? Debbie
-
Nested Formulla
-
How to use OR for COUNTIFS, referencing 2 columns in another sheet
Hi, I have the following formula in a column, =COUNTIFS({Sheet Range 1}, [Column Sample]@row, {Sheet Range 2}, "ABC", OR({Sheet Range 3}, >TODAY(), {Sheet Range 4}, >TODAY() I need to do if column A = 1. column B = 2, (next should be OR) or column C = 3 or column D = 4 Please help out!
-
How automatically update a report date when a project sheet is updated?
I've built out a portfolio where all project plan sheets have a summary sheet that rolls up to a portfolio report along with all the other summary sheets. Each summary sheet has a "latest update" date field field where I have to manually enter the date of any changes/updates are made to the project plan sheet. Is there any…
-
INDEX/COLLECT Giving #INVALID VALUE
I have a sheet set up with a form for employees to enter their name, hours, and week ending date on a weekly basis. In order to create a dashboard chart to compare all employee's hours week-to-week, I've set up a separate sheet to reference the entry sheet with the week ending dates as the primary column and employee names…