-
Multiple nesting help!
So I have 6 survey questions with response options of "below expectations, meets expectations, and exceeds expectations." I need it to tell me how many below expectations for question 1 are in each region and so forth for each response option and region. So far this formula works great! =COUNTIFS([Delivery…
-
IF condition is true, copy a value into another column
I have a sheet where multiple people have to approve an item before it is 'approved'. I am needing to copy a cell from the Cost column into the pending, approved, or rejected column based on the current status. So if the P/R/A column equals "P" I need the $ in the cost column to populate in the Pending Cost Column, etc.…
-
Expand/Collapse rows
Expand / Collapse all is not an option on my primary nor any of my parent rows. Why?
-
Off-line Client / Integration or Workflow Recommendations for Smartsheet
My very short question is: After researching that Smartsheet does not offer a desktop client or offline mode, are there any software solutions on the market that offer an integration from Smartsheet to a client based application; or perhaps a workflow you've worked out for offline users? Our Story Smartsheet became an…
-
JIRA Sync To Smartsheets Not Syncing
The Problem: JIRA is actually not auto syncing like it should to pull in tickets automatically into smartsheets Notice: The workflow is set correctly to sync JIRA fields to smartsheets The Problem: We have to go into this workflow manually, edit it, then let it run every day. This is NOT automatic syncing like its intended…
-
Formula to calculate difference between projected and actual dates
I have a project schedule where I have projected and actual dates for most of the deliverables, and I need to track the faster project path. Is there a formula that can automatically select the earlier date between the projected submit date and actual submit date? Is there a formula that will automatically select the…
-
Setting up billing rates in grid view?
As a newbie, I'm trying to set up billing rates in Grid View by job title, but I'm finding the help documentation in SmartSheet lacking (see attached screen shot). Is this even possible in Grid View? Or is Gantt View the only option? Or, is conditional formatting the only approach? Any input or ideas would be greatly…
-
Atlanta-Based Construction Expert?
Hello - we are a custom home builder in Atlanta and are interested in setting up SmartSheets for our company. We do not have in-house expertise and are looking for a consultant to set this up for us. Please let us know if you are interested or have a consultant we could engage.
-
Sorting & Filtering Linked Cells From Source Sheet
I am unable to figure out how to sort and filter linked cells from the source sheet. I have a sheet with cell links which needs to be sorted or filtered when the source sheet is sorted or filtered. I am unable to use a report or dashboard for this function due to the need for a specific layout, exporting and printing. The…
