-
Status Symbols
We don't want project teams to use yellow ball. Is it possible to have only Red and Green Balls as Drop Down Options to select for Status?
-
Record the number of times tasks are sent for review and need rework
Hi I have an automated flow with a status and want to record the # of times an operator changes a task to "for review" (which automatically notifies the review) and it goes back to "to do" because the reviewer doesn't accept the task as submitted. I looked at an IF function to write YES or NO to a hidden column so we can…
-
How to create formula to count upcoming tasks in the next 90 days?
I want to see how many tasks each project I have are upcoming in the next 90 days. I can run a report to see this information, but I want to be able to display it in an easy to read chart with each project showing how many tasks they have. See attached example. I built the attached chart by running the report with the…
-
Cross Sheet Logic/Data Sync
Hi, I have a signup sheet that I am trying to get to update from another sheet. I essentially want to take "Unique Code from cell X on Sheet A and look for it anywhere in Column "Code" on Sheet B. Once it finds it on Sheet B, I want it to return the data contents from another column in the corresponding row to Sheet A. For…
-
Using IF to look at a Checkbox field and return "XYZ"
I am creating a Status field using IF function. I'm trying to look at a check-box field and return "status" (ex. "Tooling Complete") if the box is checked. I've tried IF(NOT(ISBLANK(... but a check-box formatted field seems to register as not-blank whether it is checked or unchecked. Does anyone know a different function I…
-
Automatic Checkbox w cross-sheet & lookup
I'd like to create a series of formulas in a sheet that will automatically check a checkbox column if certain conditions exist. The 2 sheets are ATTENDANCE and SIGN IN. The Sign In sheet has attendee names in the first (non-Primary) column (in the order that the attendee signs in, not alphabetized) and has a date in…
-
Nested if()
Hello great community. I'm new in Smartheet and I've a problem and even don't know if a solution exists. I'm trying to create a sort of automatized timesheet for my team. I would like them to connect to the same sheet. They have to select their name in a list ("Team" column), and the type of mission they've managed in an…
-
Work days formula
Hi, Is there any way you can advise of a formula where I can set something up that picks a date in a column and I set a specified number of working days which yields the final date. So if I have a cell with a date of 10/09/19 and the working days I want to set is 14, what would the formula be like? I have tried using the…
-
Mandatory text to activate checkbox
I have a "Notes" column that requires text before the checkbox under "Req Attn" will be checked, kicking off conditional formatting in other columns. I found this thread and tried to implement the suggested solution: https://community.smartsheet.com/discussion/formula-help-if-cell-blank-checkmark-cannot-be-checked I…
-
COUNTIFS - Overdue tasks
Hi, I am trying to count live tasks that are overdue but I am getting #INVALID DATA TYPE This is the formula I am using =COUNTIFS(Status:Status, <>"Complete", [End to End Due Date]:[End to End Due Date], <=TODAY()) Any ideas? Thanks Karen