I am looking for a simple formula to multiply [Quantity] times [Cost] only if there is data in the quantity cell. Currently the [total] column fills with $0.00 if there is no data in these columns. The "HELP" page is not clear to…
Using Smartsheet157Al W
The new Proofing capability is something we would like to implement in our department, but we are having issues with accessing this in Reports. We see that Proofing can be done in the main smart sheet, but our Artists access new design req…
I would like to send a notification with an attachment based of a status change. The notification works, but doesn't include the attachment. I have seen on the community that this is not possible in SS - is this still true?
API & Developers153katherinehall
I am trying to create an aggregated view of data from multiple sheets using the "Sheet Summary Report" but when get to the Builder, it only shows the system columns for display. Obviously this is not helpful if I cannot merge tog…
I have a sheet published in Card View on our company Wiki page with Read Only - Full features.
I'd like to have the ability to set the Published Card View to match how I have my sheet set up and not a generic Card View.
For example, I h…
Using Smartsheet24[email protected]
Has there been any progress with adding card view to reports? Has this been an approved feature and scheduled for a release? Our company has been pushing a move to JIRA because of the gap with smartsheet in allowing our teams to vi…
Using Smartsheet355Jess Evers
i am trying to work with smartsheet webhooks. Would like to use the callback authentication feature as explained at http://smartsheet-platform.github.io/api-docs/#authenticating-callbacks-optional.
However, the instructions are not very c…
Does anyone know if there is a way to NOT display a contact's full email address (but show their name, instead) when they are assigned as "Task Owner" in the Smartsheet Calendar App?
We have a calendar that references an existin…
Premium Apps and Integrations37Kyle Morgan
Please see attachment.
I need help with counting the number of cells in a column, (see attachment: Column [Response Sufficient?]) that contains an exclamation mark(hold) or is blank.
I basically want to count the amount of RFIs with…
Formulas and Functions46[email protected]
Background: An International source Smartsheet has 1700 rows (and counting) and 85 columns. Using the Index/Match formula, we reference 14 columns of data within a new Regional Smartsheet. Why? Regions want to add additional Country-focuse…
Formulas and Functions207EmilyH
I'm trying to generate custom PDFs with a specific template from a smartsheet row. The workflow currently uses an automation to send an email when the row is "done". Right now, that email contains the "Row Number" …
API & Developers57bcromie
Does Smartsheet have a type of version control?
After seeing very nice dashboard presented in Best in Class Project Management video I tried to start developing something similar for our organization. However I'm struggling with creating customized buttons (like "Home", "…
Using Smartsheet211Maxim Lobko
I am using Smartsheet and I am involve in 3 projects and all are main and lead roles. I made 3 separate sheets for each project but I realize each projects affect the other projects and then sometimes the predecessor is in another sh…
My team and I are new to Smartsheet, and after 2 days of using the software, have already found a couple of major road blocks that will likely keep us from using Smartsheet.
The biggest is the inability to create a drop down list that us…
I am trying to find out the best way to work with smartsheet in a particular scenario.
I have project smartsheets that outline project milestones, and tasks within. This sheet is shared externally to my team for collaboration.
User story in Jira are estimated in Story Points (0.5, 1, 2, 3, 5, 8, 13, 21...) where each story point can be mapped to ideal days range such as a
0.5 story point = 1d,
1 story point: =2d
2 story points = 3d
3 story points = 5d
Premium Apps and Integrations104NKH
Please develop the ability to share Pivot and Datamesh configs. It is difficult for me to support my users when I cannot access their Pivot and Datamesh configs. Also, it makes it more convenient in training users when they can see what I …
Premium Apps and Integrations15Cody Stevenson
When requesting an approval, I want to be able to send the decision to "contacts in a cell" and cc a "specific person". It appears I can only choose "Specific People" or "Contacts in a Cell" when det…
Formulas and Functions25Pam Grant
- import of a google/excel sheet containing an "Assigned To" column fails to assign to known smartsheet users any of the tasks listed in the file that was imported with matching user names/email addre…
API & Developers30adgcz
Does anyone have a template or know of an existing template that could be used for OKR's?
Is there a way to have a row come in automatically at the same indent level as the row above it? My top row is a parent row with calculations based on all of its children. The children rows are all web form generated and they do not come i…
I am using the following formula to represent health color for individual rows:
=IF([Start Date]40 > TODAY(), "Blue", IF(AND([% Complete]40 < 1, [End Date]40 < TODAY()), "Red", IF(COUNTIFS(CHILDREN(), &q…
Formulas and Functions39Adam Fink
I have seen multiple threads from as far back as 2015 asking for a save button for webform
Using Smartsheet42Jia Lee
The previous system admin of our Smartsheet account has left the organisation. How do we change the system admin now ? There is a need to add more resources to our account and we are not able to do the same.
Kindly provide sug…
Using Smartsheet44C. Srinidhi Ragunathan
We all love a Freebie?
OUR API development team get lots of requests for automation which is the basis of our Smarter Mini Control Center 12 Apps, but one request we have been unable to fulfill so far (unless we use Appsheet with Smartsh…
API & Developers631Richard Rymill SBP
I have made several workflows that were fairly large for different applications in smartsheet. I would like to have a simple function to print/pdf the workflows so as to see all of one at once. This would help me with design, troubleshooti…
Formulas and Functions37[email protected]
What other options do we have to format the sheet better, perhaps even in sections?
Merging some cells will help get rid of the lines and make things look better spacing wise.
Would anyone find it useful to have a cover page for Workspaces that, when the workspace is first opened (or every time it's opened), you see a rich text explanation of what that Workspace is for and how a person could or should interact w…