-
RACI Template???
Hi Everyone, I have been searching Smartsheet, google and this community, but cant find these types of RACI templates. Has anyone had any luck?? It's weird Smartsheet would post articles about these RACI formats, but not actually have them in Smartsheet. Any help would greatly be appreciated as my attempts to create have…
-
How to - Create report filtering on rows containing "Pending Open Update Request"
I have not found a method/solution to generate a report on the leftmost system columns and various statuses such as "Pending Open Update Requests" or has attachments, etc... Suggestions or How-to would be greatly appreciated!
-
I am trying to find the right formula referencing dates and an identifier column
I am working on a formula to check all boxes in the rows that match the identifier column if there is a projected date and it is greater than or equal to today. I collect the start and end date and if a class is delayed or ahead of schedule it collects the projected end date. What I want is if the class is still going on…
-
Simple Payment Tracker?
I'm trying to track payments for several homeowners over a period of time. I already have homeowners in individual rows in other workflows and I copy them to a payment tracker, shown above. I'm not sure how to track their payments in a way that makes sense... I started with each column representing a month, so we can fill…
-
True/False IF formula not working?
I noticed that the formula I was using wasn't working so I moved it to a text column to see if the output is correct. Turns out the output is giving me 0, so no wonder the checkbox isn't checking! My issue is that I'm trying to get a checkbox to check if the values are either -5 or 5. However, I'm stumped on what I'm…
-
Are you able to change the third line down on a conversations email?
When someone is mentioned in conversations, is there a way to change the row it refers to (in this example: Row 40: Admin Lead QC - Prior to Technical QC) This is a task name I have added, but I am wondering if there is a way to change what column this feature picks up? Thank you, Alicia
-
Filter rows under parent row?
Good afternoon, I was wondering if it was possible to filter rows submitted by a form depending on a priority. For example I have 3 parent Rows that are High, Medium, and Low priority. If a new issue is submitted via the form for a High Priority. Have it automatically sort under the High Priority Parent Row? As of right…
-
Blank Data sheet but still sending automation
I was working on a page and doing some automation testing before it went live. I have a section where there is a drop down menu to select people. Using the form i have sent some automations to show them what it would look like getting the email but even though i have deleted the data from the sheet, they are still getting…
-
Using CONTAINS or LEFT in a COUNTIFS
I am trying to create a helper column to flag when there are not enough safety cones in a vehicle depending on the vehicle type. For example Pickups need 6 minimum, Vans 8min and Buckets 12min. The types vary with PICKUP/FORD, PICKUP/CHEV, Pickup - Service Body, and Pickup. My first thought was to do a contains in the…
-
Task completion (%)
Hello everyone, is there a way to set the % complete based on the task status? I have a table [state ; % complete] I tried with "VLOOKUP" function but isn't possible to insert formulas in the field. Help me please! Thanks
