-
Simple multiplying formula question
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 me on how to do the ISN'T Blank formula. Thank you Al W
-
Formula needed
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 an exclamation mark or blank cell in the [Response Sufficient?] column. I have used the…
-
How can I remove a sheet reference, so I do not receive the alert ‘Reference a total of 25000 cells
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-focused data, data that should not be managed on an International sheet that already has 85…
-
Row Id in email
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" which is the only way to identify the row through the API (all the rest of the columns can be duplicate…
-
Version Control
Does Smartsheet have a type of version control?
-
Customized Buttons in Dashboard/Portal
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", "Portfolio Dashboard", "Departments" etc) that you can see on the top of the dashboard that is used…
-
Drop Down List Data Validation
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 uses data validation to pull a list of options from another Sheet. (Example - one sheet…
-
Can I change tasks visibility in a shared smartsheet?
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 cases, some of the tasks might drive subtasks, or small actions that the internal…
-
Build Gantt Chart based on JIRA User Stories Story Points estimations
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 ... Theoretically it is possible to build a gantt chart of the N user stories as follow User…
-
Combine "Specific People" and "Contact in a Cell" in the the same approval action
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 determining the action from that approval. I have to create a separate workflow based on the population of the approval column.…