-
A Template that is more friendly way to set this up
I hope that my screenshot is helpful, but i am still using new tools in Smartsheets, but i was wondering if anyone had any idea of a way I can set up my 1x1 meetings, per supervisor in Smartsheets. So i have 3 departments, and each department has about 12 supervisors each, and those supervisors have about 12-18 employees…
-
If Column is Greater than 0 Change Health Bubble to Red
Can someone please help me with this formula. Everything is working, other than the last section of the formula (IF([B/O Quantity]@row (greater than) 0, "Red") Sorry, it won't let me put the greater than symbol in the text box. I want when the "Health" column to turn red whenever the "B/O Quantity" is greater than 0 OR…
-
Conditional formula
Hello! I'm trying to write a formula where the I account for back filled data and then data with a timestamped "Created" column date. How can I combine the following two formulas? The one for current data: =IF([Backfilled Data]@row = 0, IF(MONTH([Date Submitted]@row) = 1, " (01) January", IF(MONTH([Date Submitted]@row) =…
-
Formula to show only certain parent row names
Hello! I have figured out how to specify if a row is a parent/child row (we call them Project/Tasks). I am trying to find a formula that will automatically pull from a specific parent hierarchy. In this case, it will always be the parents that have only been indented once (rows 22, 31, and 38). Rows 32 through 37 show what…
-
Merged: Sharing contacts in different sheets
This discussion has been merged.
-
Formula for SumIF
I need the formula for the following Sum of ($ value column, in another sheet), if value of another column = jan (which is a date column in same sheet as the value) This will forumla will be in another sheet.
-
Auto Add a Number After Auto Numbering
I have a master sheet which captures data and assigns an auto-number (Incident Number). When a row falls into a certain category (Warranty), it gets copied to a new sheet. I want to be able to take that unique Incident Number and add to it. This is what I have so far: It puts a prefix onto the Incident Number, but I also…
-
How can I update a checkbox on a sheet based off of criteria from another sheet?
I'm trying to update a checkbox on a sheet based off of criteria from another sheet. I've seen several examples using the INDEX / MATCH function but haven't had any luck because the situations seem to be a little different than mine. Here is my situation: Sheet 1: Time Tracking - updated by each employee each week via a…
-
If, Index & Collect Formula issues
I have an issue with my current If, Index, and Collect formula. I have two sheets. One for data collection, and another for the Reviewer's Agency, Schedule, and Email address. I want to automate this process where if I have a TFD C shift, the Reviewers email address will be added into the data collection sheet. Here's my…
-
COUNTIF as of Today?
Hi, I have a sheet I'm using to calculate the number of open tasks on my project. =COUNTIFS({Corporate MOC Location}, CONTAINS("BER", @cell)) The reference sheet is constantly being updated as and when actions are completed. I want to cell link this count to my KPI sheet to track the performance of the team over the course…
