Product questions?
Ask it here! The community's got your back.

Smartsheet Basics

Ask questions about the core Smartsheet application: Sheets, Forms, Reports, Dashboards, and more.

Sharing a Filter By Current user report without sharing the sheet
Here is what I am attempting to do. I have a sheet where people use a form to submit requests. These could come from anybody in the company (over 100,000 people) I would like to have a report, on a dashboard, where these people can come in and see the status of their request. I was hoping to create a report, filtered on…
I'm not sure why my automation is not working?
The automation is supposed to have an alert going to a contact when a row is changed. It is based off of an equation that turns a cell "Red" when a date over two weeks has passed. This equation works but the automation is supposed to send out an alert when this change occurs. When testing with "Run Now", the message goes…
Generating an email to multiple users?
I am wondering if there is a way to mass email users from within Smartsheet. That we can place on a dashboard, as a like "here's where we can send an update or notification to all programs". All I can find in my research is automations for form completion, reminders, etc. Is there something out there for this? Thanks in…
Split contacts to multiple columns.
In my sheet, I have multiple contacts in one cell. I would like to AUTOMATICALLY spread these contacts across multiple columns in the same row, so that each column has one single contact. The reason I want this is to send approval requests to each contact. (Currently, I can only send approval requests to all the approvers…
TRYING TO COUNT MULTIPLE DATA IN A COLUMN
looking to count all the data from 4P100,4P200,4P500 etc in one row the deal I have is 0-500 501-1000 1001-1500 I am not wiz at this but I am trying to learn
Monte Carlo Simulation
Is there a way to run a Monte Carlo simulation in smartsheets?
Export formula to Excel
I am trying to export a budget sheet that has formulas to Excel and still have the ability to manipuate the numbers with the same formula, but it does not carry the formula with the export. Is there a way to preserve that formula during export? or is there some other way to export the data and keep access to the original…
Some parent %complete displaying in decimal
Hi, I am using a project sheet with dependencies and predecessors activated. This makes the parent row %complete un-editable as it calculates based on the children. For some reason, some of my parent rows display the %complete in decimal while most others display in percentage. Is this a glitch? I can't seem to change the…
Creating a custom error message on a form for "skipped" mandatory fields
Form asks to select a whether they are interested in a job. If the user clicks yes, I used logic to ask another question about that job and marked it as mandatory. When the user skips the mandatory question he is unable to submit the form and gets the error message the information you entered is incomplete or invalid I…
SmartSheet API Report Source Sheet
Has anyone been able to access the source sheet of a report using the API? I am using Python.

Popular Tags

Trending in Smartsheet Basics

Date Formula Help Needed!
My current formula seems to count weekends and then also seems to count the day of as a day too - can someone help me rewrite this so days until due for 1/17/2025 would show as 1 and not 2, and then also skip weekends? Formula in case its hard to see below - =IFERROR(NETWORKDAYS(TODAY(), [Reporting Due Date]@row), "")
Retrieve value from "Top Parent" when Ancestor level = 2
I have a project management sheet. CSYYXXXX is the header for the project name column Tasks is the tasks column - at the parent row, I just write "Tasks" and then there are child rows below that. Some of these child rows and another level of descendant rows. I want a column formula (to serve as a helper column for various…
Target Date/Delta info vs Baseline in PMO plan template
Hello! I've read through several past posts related to this but couldn't quite find my answer. We are using the PMO plan template and have activated the baseline feature. My manager has asked if there is a reason to keep the Target Start/End date columns as well as the related Delta columns since they're basically the same…

Help shape the future of Smartsheet.
Share your ideas and feature requests.

Watch video

Smartsheet Basics

Discussion List

Categories

Popular Tags