-
Creating an At Risk Formula
Hello Community, I am trying to create a formula that will create a flag if the tasks are not marked as Completed in the column that says complete, and the Due Date has been exceeded by 5 days. I've had headaches trying to figure this out. I would be very grateful for any assistance you can provide with the IF formula…
-
Trying to Count number of items with a date in the next 60 days
Morning! I have a sheet that I want to count all of my projects starting in the next 60days. I have used this formula, but it's giving me the wrong answer. I know I have 6 jobs that start in the next 60 days (from today) =COUNTIFS({Master - Jobs In Progress Anticipated}, @cell >= TODAY(60)) Where's the error? Thank you!
-
Number of Month Payback ROI
Hi everyone, I have created a form and the pictures below is what is relevant to my question. We have projects with a fiscal year start date and end date, we also want to know the payback date. I did not chose the "date" function on the column as we are only interested in the fiscal year, but maybe there is a work around.…
-
INDEX MATCH range across a row?
Wise People in my Computer, Can I set the range for an INDEX MATCH formula across multiple columns in one row, instead of a column? My testing is suggesting the answer is no...am I missing something, else what might I use instead? I am trying to return the name of a Reviewer into my Lead Reviewer column, pulling from the…
-
Question on SumIFS
We're hosting a "Bike to the Moon" where our supporters are uploading their daily trips, miles and emails in a worksheet. We want to display a riders' individual trips (showing date and miles traveled) and a total miles field that sums across all their trips (rows.) I'm using this formula at the moment but I'd rather not…
-
Can selections from a list be added to each row under a job based on job criteria?
I am not thinking this is a possibility, but thought I'd ask in case I missed something. Can a list of tasks be populated in the rows under a new job row based on criteria in a different row? For instance, I have a column for project type and a column for project tasks. If Sign is selected as the project type, can…
-
Keeping track of dates
I want the time a specific cell is edited to be automatically placed in a cell. I don't want to use the column setting because that updates when any cell in the row updates and not just the one I want. Is there a way to do this?
-
Smartsheet for project managment
I have enjoyed using Smartsheet for many years now. I wish I could find an easy way to become more skilled in formulas. I love how Smartsheet brought my customers, reps, factory and distribution, and even in field techs, into one live environment. It saved so much time, and really makes me happy to see this company grow as…
-
Formula within a formula
Good afternoon everyone, I was wondering if it is possible to do an IF formula with a date formula in the same cell? I would like to do the following, but also subtract the number of working days between two dates. IF(Status@row "Complete", 0, ..... Below is the formula I have now.
-
Gnatt Sheet Calendar
On the Gnatt Sheet, can you have multiple duration columns to show multiple dates within 1 row? Thank you! Tiffany