-
Formula Question
Hello: Below is a formula that was written to change the verbage in the "Status" column based on the % Complete Column. The original formula was =IF([% Complete]@row = 0, "Not Started", IF([% Complete]@row = 1, "Complete", IF([% Complete]@row > 0, "In Progress", IF([% Complete]@row < 1, "In Progress"))) and it worked just…
-
COUNTIFS with Previous date or date to come
Hi, I'm having difficulties with the COUNTIFS formulas and dates. I have a table from another sheet in which I am interested in four columns (Track, Type, Due Date and Done). I would like to know the number of rows where track = "customer", type = "track action", due date = is greater than or equal to ten days from today…
-
Calculate the difference between dates & Times
Hi, We use smartsheets to log support queries. I want to calculate the turnaround time between two dates: Date the ticket was loaded and date that the ticket was closed Date format: mm/dd/yy x:xx PM or AM Is there a way to calculate the turnaround time?
-
Auto Send Email Template
Hello guys, I'm trying to build Hiring Candidate Process so I want to build an automated sending email with a premade template, can smartsheet do that? for example: 1st interview => fail => send "thank you" email Thank you very much, hope you guys have great day
-
Is there a formula/function to help count number of children assigned to specific parent tasks?
Hi all, I'm trying to put together a table that lists the number of sub-tasks (children) in each respective Workstream (parent) of a specific Project Plan, and also breaks these down into their respective Health Status (Green, Yellow, Red). I am aware that I can apply a "COUNTIF" formula and set the range to encompass the…
-
JOIN and COLLECT
This discussion was created from comments split from: dropdown multi-select and lookups -- vlookup, join, collect, index, match???.
-
Days to due Date
Hi All, Is it possible to have the column 'Days to end date' auto-populate from the 'end date' i.e indicating number of days after end date, when status is not 'complete'?
-
Red flag on/off control to indicate project RISK
Hi All, I have a column named 'risk' and the flag only toggled on when certain conditions are met- uncompleted activities that exceeded 30 days after the planned end date; =IF(Status@row = "Cancelled", 0, IF(AND([End Date]@row < TODAY(30), Status@row <> "Completed"), 1, 0)) It works pretty well but, I would like it not to…
-
Status Report Red, Yellow, Green for Current Week on Dashboard
Hi there, I'm trying to build a formula to pull in the current week project status and include that in a widget in the project dashboard. Our status reports are done weekly and include multiple workstreams. I only want to pull in the current week status for the Project Management workstream. Example: Project Management…
-
I need assistance in making this formula work
=IF((Completed29) = 1, TODAY(), (=WORKDAY([Install Start]25, +5)))