-
Import contacts for templates
After importing contacts (csv file) into a sheet we're using as a template and then sharing that sheet for others to use, is it possible for the contacts to remain in the template? I am trying to eliminate every smartsheet user from having to import contacts individually and simply do the work upfront on our templates.
-
Resource contouring -> variable allocation per day or week on a single task
Hi All, we often have changing allocations for team members on a given task - ie no a flat 50% allocation for one task across multiple days. For instance - that person's allocation may be 25% the first day 50% the 2nd and third, 100% the 4th and 25% on the last day of the task. This is known as resource contouring in MS…
-
Find reports using a particular source data?
Is there a way to find all reports that use a particular sheet as source data? We have one giant sheet that is the mother of all our sheets, and we plan to make substantial changes to it but first want to know what reports are hanging off it. We want to quickly and easily find all impacted reports and resolve any issues.
-
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…
