-
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 Smartsheet157
Al 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…
Using Smartsheet100
amontemayor
-
Hi there,
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?
If…
API & Developers153
katherinehall
-
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…
Using Smartsheet394
amwright100876
-
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]
-
All,
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 Smartsheet355
Jess 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…
Using Smartsheet58
amitk-productiv
-
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 Integrations37
Kyle Morgan
-
Hey
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 Functions207
EmilyH
-
Hi!
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 & Developers57
bcromie
-
Does Smartsheet have a type of version control?
Using Smartsheet60
danzap
-
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 Smartsheet211
Maxim Lobko
-
HI,
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…
Using Smartsheet279
Dynamics
-
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…
Using Smartsheet311
kaitlin
-
Hi,
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.
In many…
Using Smartsheet27
rcabral
-
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 Integrations104
NKH
-
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 Integrations15
Cody 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 Functions25
Pam Grant
-
Dear Smartsheet,
The issue
- 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 & Developers30
adgcz
-
Does anyone have a template or know of an existing template that could be used for OKR's?
Using Smartsheet659
brettwad
-
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…
Using Smartsheet120
RossL
-
Hello,
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 Functions39
Adam Fink
-
Hello Smartsheet,
I have seen multiple threads from as far back as 2015 asking for a save button for webform
https://community.smartsheet.com/discussion/1909/saving-coming-back-to-a-partially-complete-web-form
https://community.smartsheet…
Using Smartsheet42
Jia Lee
-
Greetings.
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 Smartsheet44
C. 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 & Developers631
Richard 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.
Using Smartsheet34
beatea
-
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…
Using Smartsheet52
brianmorgs
