Smartsheet Basics

Archives for May 2021

Need admin approval while logging in Smartsheet
When the free users try to log in Smartsheet via app.smartsheet.com with Microsoft company account, some of them gets this notification. "Smartsheet needs permission to access resources in your organization that only an admin can grant. Please ask an admin to grant permission to this app before you can use it." Who is this…
Workflow triggers wrong notices
Hi, I have no idea why smartsheet workflow suddenly start working wrongly. The workflow is to be triggered when a row is added or changed (this usually happens via form which gets submitted). The email address specified is to get a notice and details from selected smartsheet columns but approx one or two weeks ago, the…
approval when a row is marked complete
I am trying to add an approval when a specific row is marked complete. I do not see a way to do that. I want to add sign-off of a phase when the milestone is complete (eg. Task = QA complete Status = complete) Is there a way to do that?
Referencing a date in another smartsheet
Hello everyone, I am trying to create a master smartsheet to give me the first date in a column in another sheet. I have tried cell linking but if a new row comes in it does not update. I don't know if this is possible but would appreciate any help.
How to input a date/time and calculate a time elapsed?
I'm brand-spanking new to Smartsheet. We are trialing it for work and I'm trying to convert some of my Excel workbooks for use in this new platform. A really common formula for my work is =(Time1-Time2)*1440 which gives me a total time elapsed in minutes. I then build my dashboards to take those calculated fields and do…
Same row versus different row in Reports
Hello, Scenario: I have two sheets, sheet A and sheet B. On sheet A there is a column titled Survey Number, this is where the user enters the survey number. If I was to input data on Sheet B, can that information be linked to the primary column instead of creating a new row in the report? See how there's a new row (line…
Forms Workaround: Submit button opens new form to allow sub-info - How do I stop when user is done?
Please help! I'm stuck. Goal: Create a form customers can use to report a problem with an order. The order may have more than one line item (i.e. Customer ordered 5 received 3 of product #1-ABC and ordered 3 and received 5 of product #1-ABE, both on same order) I want the customer to be able to provide their contact…
Possible to display 2 bars in Gantt view for 2 sets of start/end dates on a task?
Thank you in advance if someone can help with this question. I have a sheet of tasks assigned to owners. Many tasks have 2 actions that need to be performed, each with their own start/end dates. When I switch to Gantt view I see one bar for each start/end date. I know how to toggle between the 2 sets of date columns using…
How do I avoid the cross sheet cell reference limit of 100,000?
I have several formulas that are critical to one of my dashboards. They reference a master sheet that grows daily in number of rows. I end up getting the cross sheet cell reference limit warning about every 15 days. Is there some way to easily mitigate this? I'd like to avoid reducing the size of the master sheet so…
New "change cell" automation
Liking the new functionality but having a problem in the following fact pattern. We have a project sheet with all the usual project columns (Start Data, Duration, End Data, etc.). Want to change the End Date value to the date on which the use changes the status column to Complete. Doesn't seem to let me do that. The reason…

Trending in Smartsheet Basics

Creating Graphs
Is there a way to create a similar graph in Smartsheet? Thanks!
Activity Log Error for the past 3 days?
For the past 3 or so days, in the activity log, when trying to expand the view to see what cells changed, I receive an error message saying we are having trouble reaching Smartsheet right now. Is anyone else having a similar issue or is it just me?
Does Smartsheet work Offline?
Dear All, I would like some advise if Smartsheet can work offline. Thank you very much.

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

Watch video

Smartsheet Basics

Discussion List