-
RYG balls formula displaying text only
I've read through all the replies on this but have not found the resolution yet I want to display RYG balls in a new column i created that corresponds to the project Status and Finish Date. The new column Properties is RYG Balls The formula works, but only shows as text Formula i created: =IF(Status@row = "Complete",…
-
Automating RGY balls
Hello, I am trying to automate the Red, Green, Yellow balls in my project plan but I can't seem to make the formula work. I want this to be based on 2 criteria, one being % complete and the other one on the end date. So I've tried something like =IF([% Complete]1 < 1, IF(TODAY(3 / 5 / 2019) - [End Date]1 > 0, "Red")) and I…
-
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…