-
PLEASE tell me what is wrong with this formula
=IF(Status8 = "Complete", "Blue", IF([Due Date]8 < Today8, "Red", IF([Due Date]8 = Today8, "Yellow", IF([Due Date]8 > Today8, "Green")))) Very new at this, but I can't see the problem...
-
Keeping old and new data when needing approval/decline
We use Smartsheet for forecasting budgets per team. Each team has its own sheet with each line item that rolls up to sheets, reports, and a dashboard (with graphs and metrics). The columns represent both forecast and actual money spent per month (two separate columns per month). When a product owner adds a forecast amount…
-
SUMIF value exists, leave blank if cells are blank (nothing to sum)
I'm trying to figure out how to create a formula to sum a column if there are values, but leave the field blank if there are no values in the range. Is that possible? Here's the background: I'm trying to create a status report that shows whether or not someone has actually entered values into the appropriate column. If…
-
Supplier Management - Template
Hi, I cannot find a pre existing template in smartsheet templates Do any smartsheet users have an existing template on their smartsheet account for Supplier/Vendor Performance or Evaluation, preferably with pre defined criteria, and pre formatted score chart and graphs? If so, are you happy to share this template? Thanks
-
form data capture
I am collecting daily sales totals and transaction totals with a form. The store manage enters the totals into a SS form daily and it populates the SS. I would like the entries to sub total into months as they are added to the SS... then those monthly totals can roll up onto a dashboard, along with other department…
-
Time with fractional seconds
Good morning, I am using Smartsheet to track swim time which has a format of minutes:seconds:fractionalseconds (i.e. 5:00.50). I would like to see if anyone has a solution for a couple of issues I am seeing: 1. I would like to use the MIN function to look across multiple cells (swim meets) and pull the minimum for the…
-
Card View. Being able to display a lane by Checkbox.
Hi. I have a grid that has a primary column, a few other text/number columns and then 5 Checkbox columns. The primary column is used to identify a staff member, the few other columns are for misc. information and the checkbox columns are setup (5 in total) as the 5 days in a week (M-F). The grid and form works. I am trying…
-
Auto Email Notification
We are using the automated email notification to notify all shared users of changes to a sheet on a weekly basis. The email received by the person who made the majority of the updates does not show their updates, yet these are shown on the email received by all other shared users. I've not come across this issue previously…
-
Parent row based on children status and due date formula
Hello, I have a sheet that tracks event deliverables for 150 or so events each year. The way the sheet is set up each parent row is the event name, and then the children rows are each task for that event. I have a column for Status with the options for Complete, Not Started, and In Progress. I want to create a new column…
-
Renaming of attachments?
Good morning, I did a search in the Community, so apologies if this has already been addressed. Is there a simple way to rename attachments? We have several Word/PDF attachments and need to rename them to our internal naming convention protocol. The only way we've found is to download the document, rename, upload and then…
