Solution Center
Discussion List
-
Is there an automated workflow that populates data in cells based on triggers and conditions?In Using SmartsheetHi Smartsheet SMEs! Please share any success you've experienced in creating a workflow to automatically populate cells using select triggers and conditions without using a formula. Thanks in advance for your feedback/suggestions. Edwina -Answered - Pending Review 52 views 5 comments 0 points Most recent by Edwina Sampler-Wright Using Smartsheet
-
translating ContentIn Using SmartsheetHi all, Looking for any ideas, I am working on a sheet that is being used in 10 countries, currently, we use English as the main language, however, content can get lost in translation. is there any way for users to use their home languag…
-
OFFSET FunctionIn Formulas and FunctionsHi, I need to calculate the sum across a number of columns that will change every month (mon columns are set from January to December for each year). This would easily be done in Excel via an OFFSET function and I can't find what the equiv…Answered - Pending Review 113 views 5 comments 0 points Most recent by Heather Duff Formulas and Functions
-
Report builder - Collapse and Expand RowsIn Using SmartsheetHi, Is there a way to expand and collapse rows in the report builder just like the functionality that the sheets have? I want to be able to display in my project dashboard the same view that from the project sheet but unable to do so bec…
-
Dropdowns in a dashboard, is it possible?In Using SmartsheetI have one sheet that has metrics for a few of my employees, I was hoping there was a way to get the drop down menu function for each employee transferred onto a Dashboard highlighting everyone's metrics. *The drop downs show their total …
-
Max Cost per YearIn Formulas and FunctionsI need to determine the max Remediation Cost PER Year. I also, need to pull this information into another sheet's cell. What's the best way to go about this? This is the formula I have thus far, but it's coming out UNPARSEABLE... =MAX(IF([…Answered - Pending Review 45 views 2 comments 0 points Most recent by Genevieve P. Formulas and Functions
-
Completed Tasks removed from calendarIn Using SmartsheetIs there a way to remove completed tasks from the calendar without removing them from the sheet? I have a done column that checks off and greys out the row but the information still shows up on the calendar is there a way for it not to sho…
-
Workflow and cell linking.In Using SmartsheetI have two sheets that have linked cells. I want to use the workflow to make the tasks from the second sheet disappear if the Status column says complete. Is this possible? I know how to set up a workflow to move cells to a new sheets but …
-
How to create a time gauge or something similar?In Using SmartsheetHello, I am trying to create a widget to display on a dashboard. This widget will give the viewer an immediate idea of where the project is in the project timeline. Ideally, the widget would look like the time gauge image attached. There …
-
Can a Smartsheet form populate a PDF, and then send that PDF to SlackIn Using SmartsheetHi My company has a logistics driver that delivers sets to theatre. He usually fills in a paper form of what he has dropped off and then takes a picture of that and posts it on Slack. We have decided to move over to a paperless system and …
