-
How do I get a range of values from another sheet to feed NETWORKDAYS w/ holidays formula?
Hi, I'm super stumped on this one and can't find a solution. I have 2 sheets: The destination sheet is where I'm building the NETWORKDAYS w/ holidays formula The source sheet is called "Shutdown Days" and has 2 columns - "Client" and "Date". See screenshot below. I need to just pull the range of dates into the NETWORKDAYS…
-
time stamp
If i have a drop down "n Progress" and "Complete" can I do a timestamp in a new column when Complete is selected?
-
Formula to look at specific column/cell depending on the current month
Hello, I want to create a dashboard widget that will show employee FTEs for the current month. I currently have a sheet (Capacity Plan) that list out the employee's name, and then has the assigned projects with FTE breakdown as child rows underneath. Then I have row that calculates the total for the month. For the widget,…
-
Formula to track projects running per quarter
Hi, I have a table with a list of projects (project ID available) and related columns with Start Date and End Date each project (column in date format). I want to be able to create reports and display metrics in the Dashboard showing up how many active projects I have running during a given quarter (considering Start…
-
Is it possible to create an "If" statement that includes a hyperlink?
I have a column of data which reflects the status of a project. Statuses include "Completed", "On Next Report" etc. I'd like to embed the report schedule into the cell when the project status is "On Next Report" so viewers can easily click and see when the next report will be published. In my head, this is something like…
-
Trying to get a box to check
Good Day, I am trying to get a box in a column to check if two conditions are met: If one cell is not blank and the other is blank. I can't get it to work. =IF(AND(NOT(ISBLANK([Captain Jack's]@row, ISBLANK([Quantity (Captain Jack's)]@row), 0, 1), 0))
-
How can I get my formula to return a phrase instead of #INVALID VALUE
I have a sheet that lists job openings. There is a column formula that assigns a "status" for each job by searching another sheet of applications. For example, if a job has 3 associates applications, and their statuses are "New" "Interviewing" and "Offer" it assigns that job a status of 'offer" because that is the furthest…
-
Countifs Formula with 4 ranges is giving me a zero when there are 2 items in the raw data that match
I am using the following formula and getting zero for my result. When I filter the raw data there are 2 items that meet these criteria. I cannot find the error. =COUNTIFS({Current Performance}, CONTAINS([Primary Column]@row, @cell), {Job Family}, CONTAINS("Sales", @cell), {Month of Entry}, CONTAINS("Jan", @cell), {Year of…
-
Hiding Personal User Data
Hello All I have a process I am trying to build for my HR department to automate communication and requests. The process I have in my BETA environment: One dashboard with a form and a report widget, all user connect to the same dashboard. The form allows users to enter a request to the HR department, the request will…
-
Is there a way to set a constraint on a task's Start Date that can override a predecessor?
We have migrated a fairly complex plan from MS Project to Smartsheet and have been able to line up most of our dates. However, when Predecessors finish early on a task, the start date is impacted, as expected. In MS Project we can use constraints to say the next task cannot start early even if its predecessors end early.…