-
Help with Formula for Unique IDs
Hello, I'm working on dashboard that will track a list of vendors. Some vendors have multiple locations, so the vendor name would appear the same from row to row with other fields unique to location, while other vendors only appear once because they only have one location. Those who have multiple locations only need toโฆ
-
Overallocation flag in sheets
Is there a formula or method to identify if a resource allocation flag is triggered for a given row? i.e. have another column in the same sheet that is checked/unchecked or true/false if the "red man" flag is on for a given row? I'm trying to figure out if there's a way to summarize all of the rows in our project sheetsโฆ
-
Help with date formula/automation
I am trying to help a user automate a current process in Smartsheet. The information within the sheet is compliance info and each item has different regulatory rules. Some items have monthly update requirements, while others have quarterly or annual update requirements. Right now the sheet admin goes in the sheet to seeโฆ
-
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",โฆ
-
Countifs
I am trying to use a COUNTIFS formula and it is returning a zero, even though it should return a one...I think it is user error...I checked the reference sheet and it refers to all the columns on the sheet... =COUNTIFS({SVC Support Priority Range 1}, "[Urgent - Drop Everything]", {SVC Support Priority Range 1}, "Inโฆ
-
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โฆ
-
Rounding in Formula
I would like to round the result of this formula. =(ROUND(SUM([KR1 Calc]7, [KR2 Calc]7, [KR3 Calc]7, [KR4 Calc]7, [KR5 Calc]7)) / 3 + "%") KR1 Calc]7 = 0 [KR2 Calc]7 = 100 [KR3 Calc]7 = 100 [KR4 Calc]7 = 0 [KR5 Calc]7 = 0 Currently returning = 66.66667% I would like to round this to = 67%
-
Countifs: Using a reference for the criterion
I have a summary sheet that includes the following columns. * Ticket# * Last Name * First Name * Biosketch In the Biosketch column (and two others), I'm using the formula:ย =COUNTIFS({GH Ticket #}, 1114, {Last Name}, "Meyer", {Bio}, 1) I would prefer to use a reference to the column in the summary sheet instead of typingโฆ
-
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โฆ