-
Dynamically fill a cell with text
I have included a picture to help tell the scenario, but I'm trying to dynamically populate a cell with the question's name with the highest result. The actual form I'm using has over 160 columns, so I'm trying to find a way to automate the top result(s) with the question's name. The expectation is to eventually scale this…
-
Formula help please!
I have put this formula into a text/number cell and it is working on all lines EXCEPT the lines that match "To Aim Spraypainters" and have the Install/Pickup date prior to today. I have checked that the spelling of the text matcheS the column heading and its correct. =IF(OR([Factory Completed]@row = 1, AND(Description@row…
-
Health of Work/Color Formula Question
Hello, I am new to Smartsheet and have no idea on how to properly articulate the following rules in a formula. I am using the colors RYGB and following statuses: • New = green, if end date is one week away yellow, If end date has passed red • In progress = if % complete is between 80-90% and not overdue green, otherwise…
-
Cross-sheet COUNTIF Formula w/in a specific date range
Hi all, Looking for some help on a formula I have been working on. I am trying to count the number of requests that have been submitted between a specific timeframe (2/14/22-3/18/22). The date column I am looking at is in another sheet (Date OnlyN). =COUNTIFS({Date OnlyN}, >=DATE(2022, 02, 14), {Date OnlyN}, <=DATE(2022,…
-
Can IF function be used with symbols and cross-sheet referencing?
I'm trying to create a formula that shows the Green and Red symbols based on information from a different sheet. Current formula looks like this: =IF({Open House Order Form Range 1} = Office@row, "Green", "Red"). I get an invalid operation error but I can't figure out why. I'm wanting to know if any cell in the cross-sheet…
-
Tracking Hours of Effort
I have a column that tracks Actual Start date and a second column that tracks Actual Finish date. I need a formula to track Hours of Effort. Considering each day has 8-hour period, what would be the best formula to add to Hours of Effort column? Thanks!
-
How do I select a column from a cross sheet reference range?
I need data from another sheet. I am counting the number of non-zero instances in 6 different columns. Currently, I have created 6 different cross sheet reference ranges, one for each column. This works but it took a while to get it all setup. COUNT({reference range sales 1},>0); COUNT({reference range sales 2},>0) etc. In…
-
Hi - I am new to smartsheets and need to produce compliance stats based upon the following
I already have 1 sheet that is completed by matter managers/teams providing compliance details at various points/milestones of a matter I have created a second sheet to allow me to produce compliance details per matter manager I need to know how to compare the 2 sheets identifying/matching the matter manager in both sheets…
-
Averageif for a goal of 90%
Hello, I am trying to get my averages for monthly totals of projects. The goal is 90% but i am not sure how to word the formula to take that into consideration when calculating the average. Any insight is greatly appreciated.
-
Formula Question
Hello, I'm trying to create a formula in Sheet Summary that counts the number of "yes's" within one column based on the Month/Year of a different column. My current formula is as follows but returns "0" for a value: =COUNTIF([Month/Year]:[Month/Year], "April 2022" + COUNTIF([Action Plan Compliance]:[Action Plan…
