-
IF and BLANK nesting formulas
I am trying to use an IF statement in the approved column that says "If status is requested, return PIPELINE, all other statuses return APPROVE, unless it's blank then leave the cell blank". Everything I try returns #UNPARSEABLE. I had it working but someone messed with my sheet and now I can't get it back! Help :)
-
Export Project Dashboard to PowerPoint
Would like the ability to export a project dashboard to a PowerPoint slide while retaining active links. Right now, we have to do a screenshot of the dashboard.
-
E-mail Dashboard with active links
Would like the ability to e-mail a dashboard with active links where the dashboard image is imbedded in the e-mail vs it being a link.
-
How can I count date columns but exclude some
So I want to count a range of columns that have dates in them but exclude certain columns if the date is part of a formula. The use case is a training matrix. Each person has 2 columns. eg - "John Doe" is a date column and will get set a date when John Doe is trained to an item (Items are rows) "John Doe retrain date" is a…
-
Sync Automation Edits Across Multiple Sheets
I have a workspace that I use for all cross functional teams, internally and externally, for all active projects. Each active project has it's own project specific sheet. If I edit an automation on one sheet, there is no way to copy that same edit to another sheet without copying the entire sheet and starting over. Ex:…
-
submit ticket
Not all recipients will receive 2. Received Invoice Tracker - Open notifications2/5/25, 9:04 AM2. Received Invoice Tracker - Open SSmartsheet AutomationDue to a recent automation permission or sharing change, the following people aren't receiving alerts from your workflow: Getting this error message related to people that…
-
Adding Chart Data
It would be extremely helpful if you could make the data source side window wider, it's very difficult to see the names of the files, especially if you are working on a laptop. Having to scroll across to ensure your selecting the right data source and then remembering which one it is when you scroll back to use the…
-
Calculate the sum for each month.
I have 3 columns, Cost, Milestone Status, and Actual Operational Date (M2) I need to calculate/sum the total cost(revenue) based upon the Milestone Status(STARTED, or FINISHED), and specific for each month. In the case of the data indicated, I would need the results for November and January. I then need to surface the…
-
Form for evaluation
Hi, I am the manager of our internal Survey Programming team. In Smartsheet I have one sheet where I put all information about each project we are running. Each row is a project. Now I would like to conduct a survey after each project is closed with our researchers (there is an assigned to column for the researchers) to…
-
Formula Help
I currently have a formula to Join and Collect Date from multiple rows in Smartsheet but it is displaying the data multiple times in the single cell, I need the formula to only show each unique ID once but can't seem to get the results to work. Every time, I adjust the formula below, to try and incorporate a new function…
