I have contacted the help desk and they suggested for me to post a question on the forum.... 1. Get help with RYG Balls.... If start date is a date with no due date and at any % completed then yellow.…
I have a smartsheet and there I will let people know when certain tasks have been executed. I have already created the workflow for that. My issue is when sending the email; can I add one row only on …
Im really struggling with getting an absolute cell value to stay in a sheet or in a sheet summary. maybe im going at in the wrong direction. please help. I have a form on my call centre data sheet tha…
Currently using the Onboarding Template Set and in the Sheet Onboarding timeline, I have the Risk flag set, the current formula is to flag if the end date is in the past and the status is not compete …
I am new to SmartSheet and need assistance creating a formula or function to make it easier to to keep up with attendance for meetings once a month. Any one person from the group can attend and as lon…
Hi all. I am having an issue with getting a correct sum from children of a parent row when using a formula in the children rows. Ex: Children row formula is =IF([Date Completed]43 > [Due Date]43, "1",…
Currently our organization uses 3 separate sheets (one for each region) to track the status of onboarding our new hires. We capture things like: New Hire's Name, Start Date, who the offer letter was a…
i have a repotr based on sheet with ~1500 rows (parents and children). as i know there is no way to show the parent and children in repost so that i mark in color the parent and sort the report to sho…
Hi, I'm trying to count the number of open tickets by company name, and the cells I'm referencing are in another sheet. Here's my formula so far: =IF({Maintenance tracking Sheet Range 2} = [Company Na…