-
Smartsheet formula........
Hi, Can anyone please help me with the third part of the formula attached below? I want it to check if a column in a different sheet has a check box against the item.
-
Smartsheet formula...
Hi, Can anyone please advise a formula to calculate the workdays between two dates? I am using the formula below but I don't think it calculates the work days between two dates (Monday-Friday) =COUNTIFS({Status}, Open, {Proposed Close Out Date}, >=TODAY(), {Proposed Close Out Date}, <=TODAY(14))
-
Collect and display nearest dates
I have a job tracker designed to track the art components of our jobs. We would like to have a column display the next nearest due date for that row. My trouble is we may have 1-10 due dates on a given row and there are non-date columns between each of the due date columns. I'm fairly sure I need to use a MIN(COLLECT( type…
-
Date/Time Stamp Option
While trying to figure something else out, I stumbled across a new option for having specific actions date/time stamped using the stem generated Modified (date) type column and the new Copy Row automation. . DISCLAIMER: This does not scale very well as is. If you have a lot of rows you are wanting to track a lot of changes…
-
Track Daily Variance Between Forecast to Actuals Across Multiple Cells and Sheets into Master View
Hello, I am desperate for some guidance on the best way to handle my situation. First, I have 2 sheets that I'm attempting to provide an executive view for: * First sheet is a forecast that indicates the number of people we should be training in any product line. The individual product lines are listed in the primary…
-
Trying to use COUNTIFS and keep getting UNPARSEABLE error
Hi, I've entered this statement: =COUNTIFS(PMO Project RAG Status Range 5, <DATE(2019, 12, 31), (PMO Project RAG Status Range, "Corporate Support - Corporate Finance") What I'm trying to do is count the number of projects with the designation of Corporate Support - Corporate Finance that will be delivered in 2019. The…
-
Nested If with Multiple Check Box to Status Type
I was hoping I could get some help here. So I've decided to create a status for each of the tasks my employee is working on. Categories include: Done On Deck In Progress Not Started There is a checkbox column for each category. IF([Done]@row=1,"Done" IF([On Deck]@row=1, "On Deck" IF([In Progress]@row=1, "In Progress"…
-
Report with What and When requirements
Hello community, I need your help on this report. The solution is probably very easy, I just cannot get my head around it. I have a project plan with one column "Flag" (lines can be flagged with the little red flag) and a column with the finish date. Now I want to create a Report, which shows me all "flagged" tasks, as…
-
Automating RYG balls to change colors
So i have parent cells and dependencies. The dependencies have color balls (red, yellow, green, grey). Here is what I want: If one of the dependencies has a red color ball, I want the parent ball color to be red. If all dependencies have a green ball, I want the ball for the parent to be green If all dependencies have a…
-
Status Report based on certain conditions, i.e. dates, status etc
Hi Smartsheet community, I'm trying to come up with a status report to display information on what has been done in our projects between certain dates. I would really appreciate your expertise and help!!! For example: Project A Status Report for the period 04/Nov/19 - 17/Nov/19 What I want to show is: 1. Completed…
