-
Separating data into separate rows, under the original an auto generated column number
My department has an existing SmartSheet, to track travel. This sheet autogenerates a number based off of a form submitted for approval. The issue is that in the form staff are able to list ALL travelers for the trip, which results in the names being included in one cell. However, I need to be able to have each traveler in…
-
Project Meta Data Formula
Hello, I am using the PMO template set and somewhere along the line while customizing my project metadata sheets started referencing the wrong cells in my Project Intake Sheet. They reference the correct row associated with the project ID, but they are not pulling the information from the right columns. I have checked all…
-
File HASH
Is there a way to generate a file HASH (SHA256 or SHA512) of a file referenced in a cell?
-
What formula would auto input a number into a cell if the checkbox beside it is checked?
Instead of having to manually input $2200, can I input a formula that when a check box is checked it automatically inputs the $2200 value?
-
Flag based on % completion relative to end date
Hi guys, I'm trying to create a formula that flags, Green, Yellow, Red, when a specific % is closer to the end date. For example, if I have 95% and end date is 10 days ahead, flag should be green, however, if I have 25% completion and I am in 10 days of reaching the end date, it should be red. I was thinking of also,…
-
Workflow failed due to linked cells. Need help writing formula for Status changes.
I have the following Smartsheet and am trying to automate Status changes based on start and end dates, but from what I've read, I can't do that since my Start Date values are linked cells. Can someone help me write a formula for the Status column to populate either: Not Started, In Progress, Complete, Overdue based on the…
-
Please fix my syntax
Ok, I know it's something small but I can't see it. Can someone please tell me what is wrong with my formula? I'm getting an Incorrect Argument Set =COUNTIFS(Urgency:Urgency, "1 - URGENT Need attention today", Status:Status, "Pending (awaiting response)", "Working on it") tagging my formula guru @Paul Newcome
-
RAG Status formula scenario
Hi Smartsheets wizards, Good Evening! I have created a formula that has been working great, however I find that if the actual finish date is missing for any reason the RAG does not change to RED. Here is the formula and the screenshot of the schedule. Kindly advise what I should change to get the RAG to change to red if…
-
How to Add period only if there isn't one already?
Hello i am currently trying to use a formula that will take a name from a cell and add a period to it since it it the end of the sentence. This is the formula i use. =[Name]@row + "." The problem is, is that some of the names have periods already at the end because its words like Inc. or LLC. so how would I make it add a…
-
Forumla to add a date
Hello - I'm trying to write a formula to add a date in a cell if a checkbox in another cell is not checked, like the image below. If there is a check in "transfer to tier 2" I want closed to be blank, if there is not a check, I want it to have the date the row was entered. Can anyone assist? I've looked at automations to…