-
Harvey Balls / Lookup or Max ?
Dear all, I am trying to find a smart way to use formulas to make a large data table more accessible. The situation is as follows: I have a number of companies that are represented by one line in smartsheet. This line included a unique ID as well as names, etc. For each companies I can have 1 or more lines - children -…
-
Conditional calculation?
I am trying to create a formula that will calculate sales commission based on which marketer is named in another column. I have two marketers who are at different commission levels. I would like the Commission column to automatically calculate the commission total from the dollar value in the Services column, based on…
-
In excel you can have multiple worksheets in one document. How does this work in smartsheet?
In excel you can set up multiple tabs or worksheets in one document. How can I best do this using smartsheet? Any tips? I have a excel sheet from finance using multiple worksheets and staff names, project codes and formulas for high level tracking of time against multiple strands of work. I would like them to use…
-
Excel Dashboard Templates
Is there any way to upload an Excel dashboard into Smartsheets so that it is converted to a Smartsheets dashboard? My boss is interested in using the Excel templates but annoyed that there aren't any templates available for Smartsheet dashboards. The beauty of the Smartsheet Dashboards is that external executives can…
-
Compare two dates and apply conditional formatting
I have two columns of forecasted dates UTILITY and IN SERVICE. When the UTILITY date is past the IN SERVICE date I want both cells hilighted. For example if UTILITY = 9/30/17 and IN SERVICE = 5/10/17, I want both cells to be red. I understand That I'll have to use a third column to base the formatting from but I cannot get…
-
How to total quantity based on similar name in column
I am trying to total points based on the persons name. Basically one column has the names, some of them duplicates. Another Column has points. I need a third column for total points at the end that looks at the names, finds those that are the same and totals the points for that person in the total points column. I have…
-
Modified Date and Conditional Formatting/Alerts
I have hit a problem that Smartsheet can't seem to deal with. My goal is to create a sheet that runs conditional formatting based on the differential between 'Modified date' and a TODAY equation. Firstly I tried to create a TODAY based formula in the conditional formatting tool. However, this acted as a figure once…
-
Referencing a predecessor in formula
Hi, I would like to change a symbol cell based on the status of a predecessor completion status i.e. "If a predecessor completion status is 100% then the status of this raw should change".
-
Help Desk Ticketing with alerts that can be generated at 4 and 8 hours
We have just onboarded a customer that we want to track their IT service tickets using Smartsheet. There are two key Service Level Agreements that we need to managed to. The customer would like automated alerts generated at 4 and 8 hours. Is there a way to set up alerts based on hours vs. days? Thank you!
-
Very Large Save Causes Formula Corruption
I've been trying to understand a problem I'm having with two of my largest Smartsheets. If I move a row up or down or insert or delete a row, especially near the top of the sheet, the Save process will apparently corrupt formulas here and there in my sheet with no warning or error message given. I've gone back and forth…