-
IF () formula, Change Status Dependate on Date
I would like to build a formula so that status will change to "Red" and type will change to "Renew" when date is past "Expire Date". I've applied the two formulas separately at the top of each corresponding column. But so far it just changes it to Red or Renewed automatically, without the date dependency. Can I make this…
-
Blank display value for Symbols type?
I'm trying to recreate a switch function I've used in Project files to work in Smartsheet. It updates a symbol status column based on %Complete, Today's date, and Finish dates. I'm trying to use the green Up, yellow Sideways, and red Down arrows. Issue is, also need to display a blank in that status column if none of the…
-
Date Formulas
Is there a way in data matrix to do a formula to count the the number of lines with a due date today to 30 days out? I am trying to see item that will hit in the future.
-
Double dependencies
I am trying to create a complex schedule. I have multiple tasks that feed into two different predecessors but only one is recognized. Is there way for these tasks to both be recognized?
-
Count Check marks across columns
Hi I'm relatively new to SmartSheet and have a question. I have a set where each row represents a requirement. Each requirement may impact multiple systems. Since I'm unable to select multiple entries with a drop down - I've created 4 column - each representing an impacting system. I now need to summarize in a dashboard…
-
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.
