-
Automated Monthly Alerts
Alert Trigger I would like to send an "alert" each month on the 14th for rows in a sheet. I would prefer not to update/maintain this each month or year but just have it automatically go each month. I created a data column called Today using formula =Today() to return the current date and a text/number column called Trigger…
-
Dropdown to determine value on another column
A little help... I want to use a dropdwon column value to populate another cell with a predetermined value from a lookup column. The attached screenshot - Unit Type is the drop down and I want it to correlate to a value from pricing columns and populate the unit rate column.
-
RYB Formula Help
I am having issues with developing a formula for an overall status. What I'm trying to do is based on multiple cell-status(RYB setup column) they will dictate what the overall status column of the project status is. Both columns have gray, red, yellow, and green balls. This is my current formula please help if you can.…
-
Formula involving multiple IF/AND statements
I need to modify the following formula to include additional AND conditions. =IF(Finished12 = 1, "Blue", IF(Target12 >= TODAY(+14), "Green", IF(AND(Target12 >= TODAY(+7), Target12 < TODAY(+14, "Yellow", IF(AND(Target12 < TODAY(+7),%COMPLETE>70, "Red")))) The additional condition would be in the third if and would be…
-
Count number of checked in a sheet
Hi Could tou please help me to count the nuber og checked rows in a sheets without making parent, children rows?
-
RYG Status based on Variance
Greetings, Does anyone know if there is a formula to automate RYG based on Variance? I am trying to track budget (not dates). I would like to show Red balls when a task is over budget. Any ideas on the formula? Thank you!
-
Special IF Formula for Stars
I have two columns: * [Infrastructure Project] is a checkbox * [Product Priority] is stars (0 - 5) If [Infrastructure Project]@row is checked, I would like [Product Priority]@row to be 5 stars. If it's not checked, I would like manual entry for the stars. This would be simple if [Product Priority] were empty, but I already…
-
SmartSheet - JIRA Connector
I'm using the JIRA-SmartSheet connector to export data from JIRA into Smartsheet. I use this frequently with a lot of success. However, I just noticed something that seems a bit odd. Sometimes, I will export data utilizing a workflow with a filter of 'Labels include...x, y, z' so that my sheet will include only a limited…
-
Huge Sports Event in planning
Hey guys. I am just starting to setup a sheet for a huge sports event that shall provide all relevant info, but also be used live to update the onsite status. Basically there will be about 10 stations that will be identically except for individual timings and some details (i.e. number of people per team). My client does…