Join the Smartsheet Community
Find answers to Smartsheet questions, learn about project management best practices, discuss the future of work management, and get how-to guidance for every Smartsheet use-case from fellow users and Smartsheet experts.
Discussion List
-
Format SUM function in a reportIn Using SmartsheetHello, I have a report with a "simple" SUM function using the following: But the result shows as follows, without a dollar sign and missing a coma at the thousand point: How can I format it to show: $177,682 Thanks!
-
How to Send Timed Reminders Based on a Trigger?In Formulas and FunctionsHi, everyone; first post, Intermediate user. I'm hoping you can help me. I've set up a SS to send an approval request when a new line is added to the sheet from a form entry. I've got the automation figured out for approval or declinatio…
-
Sort Pivot table with multiple rowsIn Using SmartsheetHi team, I have a pivot table in which I selected 2 fields as Rows & dollar amounts in Values I cannot find a way to sort by descending order of dollar amount for 1st field of Rows without messing up the output sheet Here is the pivo…
-
Another Nested IF FormulaIn Formulas and FunctionsCould use your help again. Not sure why I have so much trouble with these nested IF statements but I do! When I use the formula below and the Business Unit is equal to EMEA, it returns ASD....any ideas? =IF([Business Unit]@row = "Biol…
-
CREATING A SUM RANGE FROM DROPDOWN LISTIn Formulas and FunctionsHello everyone, I am currently creating a dynamic sheet wherein it sums a certain range using a dropdown, but i cant figure how i could use the index and match formula. LINK:https://app.smartsheet.com/b/publish?EQBCT=16d13980574b4a76ac8a3…
-
Automatically Log On using Microsoft (bypass the logon screen)?In Using SmartsheetEvery time I open a sheet in a new bowser (I use a shortcut in Chrome), I'm presented with the login screen. Is there a way to craft the link so that it automatically authenticates using Microsoft (bypass that screen)?
-
Looking for an automated way to Pareto Dashboard data in a Chart Widget from a ReportIn Using SmartsheetI have large datasets with various records that have spikes and some that have only a few occurrences. Right now I have things structured in a main sheet where all the data is entered, then a summary sheet with the potential values (which …
-
Index/Match is almost completely brokenIn Formulas and FunctionsHi guys, I don't really know what's happening, and it's honestly the first time that it's happening to me. I have used this specific INDEX/MATCH syntax without issue, up until today. =IFERROR(INDEX({Office Time Zone}, MATCH([Office Number]…
-
Vacation & Time-Off ManagementIn Using SmartsheetHas anyone used smartsheet to manage time-off requests and/or vacation for a pool of staff (approx. 200)?
-
Color item no longer representing on dashboardIn Using SmartsheetI have a sheet where a person sets project status. They can choose Green, Yellow, Red, Grey or Blue. Since Smartsheet cannot handle 5 color lights, I do the following. The person can set G, Y, R or Grey directly. If their project is lau…
