-
Conditional lock
Hello, I am trying to develop a shareable sheet in which some tasks are listed along a row and check boxes are used to indicate a task has been completed. Would it be possible to lock these checkboxes if its previous one haven't been checked? In this way a process flow would be enforced. Perhaps the solution would include…
-
Graph 3 months running totals
I have a worksheet that returns the count of requests for a given week, and I have set it up to work for a year. What I envision is creating a graph that illustrates a running three months worth of requests at a time. I would like the graph to automatically update so that the range always displays the last three months. In…
-
Traffic Lights/cell colour based on corresponding numeric value
Hi, can anyone please help? I want to set up an alert system in SmartSheet that turns a cell green (and labelled 'on track') if a corresponding cell is >90%, yellow ('needs work') if 70%-89%, orange ('at risk') if 40-69%, red ('behind') if 2-39%, and blue ('not started') if <2%.
-
Text in quotes not case sensitive anymore?
Has anyone else noticed that text within quotes is no longer case sensitive? I had noticed that column names weren't case sensitive anymore a while back which wasn't an issue because when you name a column, case doesn't matter. You can't name a column as "Column" and then name another column as "column". But this is the…
-
IF formula help to gray out a status
Hi Community...having issues with this formula working for the "Gray"Status. The other criteria is working so can't figure out why I can't get gray status to work. =IF([Actual Progress]10 >= ($[Week 1 Target Progress (Aug 22)]10 * 0.8), "Green", IF(AND([Actual Progress]10 < ($[Week 1 Target Progress (Aug 22)]10 * 0.8),…
-
How to Cross Reference Data from Another Sheet
I'm trying to link data from a column in one sheet to the similar column in another sheet. What is the best way to do that? I can't seem to get the VLOOKUP formula to work properly. Thank you.
-
Countif multiple criteria
Hi, I would like to extract the number of tasks completed by a certain team using different sheet Project team IT Compleated Not Started Inprogress Project team ERP Compleated Not Started Inprogress
-
Nest IF statement
Hello! I need some assistance with a nested IF statement. I am attempting to select a contract category based on expected amount of the contract. Everything seems to work properly except when letter values are included in the contract cost which I was hoping to return a value of "Other". This is the formula I am using:…
-
HELP! Summary Report to pull from different sheets based on multiple drop down selection
Hello! I am new to Smartsheets and am trying to build a Summary Report based on drop down selections and data from various sheets. I have a TON of data and too many cells so I've had to spread it out on a sheet per month. I have two drop down selections. One is to select the month and the other is to select a division…
-
Only excluding the first weekend
Hi, I'm currently using a formula to spit out a certain number of days between two dates. I want to exclude the first weekend if it falls within the first 3 days, but otherwise include it. Currently to exclude weekends entirely I'm using =NETWORKDAYS([SALE DATE]21, [OUTPUT DATE]21) - 4 I'd like the formula to work like…