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.

Approval Requests - Logo
Is there any way to add your SS logo to the automated approval request form?
Update Request History
Often I use the "Update Request" option to send the person assigned to the Task a reminder that a task may be due or question why the Task is behind schedule. I would like to be able to see a history of my requests so I do not repeat a request for the same task. It is generally the whole row that I ask for the update on…
First Date of next quarter
Can you help me find a formula that returns 1st date of next quarter? For example, 07/17/2018 should return 10/01/2018. Likewise 08/17/2018 should also return 10/01/2018.
Manual start date with dependency
Hi. Im tyring to implement Task B only being able to commence after the completion of Task A while being able to maintain its dependency on Task A and filling in a manual start date for Task B. So for example Task A completed January 1 Task B Can start anytime after January 1 Task B Start date can be entered manually Task…
IS Blank & IS Text formulas
Hi, I am trying to create a formula to give me a specific "status" based on a couple of criteria's. My formula is this =IF(ISBLANK(RFx37), "Need RFx",IF(ISTEXT(RFxx37), "Need PO", IF(ISTEXT(POx37), "Open PO"))) I want to status cell to update based on other cells. My columns are Status, RFx, & PO. If the RFx cell is blank…
Blocking Actions on a Spreadsheet
We use Smartsheet for our work holiday/vacation planner. We don't want holiday overlaps so I would like to make it impossible for 2 employees to select the same dates. Is there a way to block actions? Is this something that can be done? Thanks in advance!
How to send the key cells of one row to related person
Hello, thanks for the last reply, it is very useful for me. Today I have a problem of how to send the key cells of one row to related person. To be more clarify, there are one row data need the boss to approve, if he approved the row then send the result to other dept. but we do not want other dept. to know all of the…
Change in email address
Dear Members, My team at work has recently decided to use Smartsheet for or program scheduling, resources and dashboards. We have procured the Business licenses via our procurement team. However, when the the licenses were given by Smartsheet the primary email address that got assigned to it was the procurement team's…
Can Webpack fullfill the full DevOps pipeline process for cloud native apps?
I am the only designer and developer for web/app development at my company. We want to create cloud native apps for cloud deployment and are looking at following the of the twelve factor app methodology. With very little experience in the DevOps/Jenkins Pipeline environment, I was wondering if strictly using Webpack for my…
How to track external dependencies
I am building a project that has external dependency to be delivered on a specific date . How do you create this dependency? Do you create a task with no duration? (start and finish date are same)?

Popular Tags

Trending in Smartsheet Basics

Remove workspace shared users from 1 sheet
We are working on setting up our Career Reviews in Smartsheets. We have a group of all staff that has access to all sheets in our workspace. I want to remove them access from just the Career Review Sheets. When I do that it says it will remove them from access to the entire workspace, which is not what we want. The only…
Schedule Dates Minus 2 days Except Weekends
I'm trying to figure out a formula. I have a customer that requires a 2 day notice that my crew will be onsite to work. I have an automation set up to remind me to send the store an email 2 days prior. In my "Notify Store" column I have a formula for schedule date -2, but I don't know how to exclude weekends so that the…
PDF Generator Automation Attachments
I've set up an automation to generate a PDF when a row of data is submitted via a form. I have another automation to generate the PDF again each time data in the row changes. I am finding that the subsequent PDF attachment is replacing the first in attachments. Is there a way to have the subsequent PDF added as an…

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

Watch video

Smartsheet Basics

Discussion List

Categories

Popular Tags