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.

Can you create auto references in a sheet
I have tasks in a sheet and have a column "our reference" can you either put in conditional formatting or create a formula so that you as you add new rows to the sheet it will automatically populate the next number, in the reference column ie 1 2 3 4 5
Link Cell from Target sheet back to Source Sheet after Copied Row function
I created 2 sheet: Source and Target. I used the Copy Row function to copy the row from Source to Target once item was approved. All work. Now I need to be able to link the cell (from certain column) from Target back to Source (as Target cell may have updated data after copied the original data from Source in). Is there an…
Dynamic/Automatic Dropdowns.
Hello, I am running a major sheet that is the core to the operational running of a Machinery Hire business. All machines have an asset number/description which are currently all manually entered as a drop down so that each machine can be selected in forms and reports etc. I need a simple way to be able to update a master…
Is it possible to query the URL's of sheets to table?
Hi there, I am trying to update some references on a roll up sheet and would like to quickly get the URL's of some key project artifacts. I'm not sure if there's a SQL type function in Smartsheet that would let me quickly let me get this data across all our workspaces. For example, I'd like to find all my Project Budget's…
Contact list "allow multiple contacts per view" & Card view
Hi community, I am facing a problem with a specific sheet and can't find a suitable solution. Every helping hand is really appreciated. What's happening? I have a sheet where our colleagues are listing their projects. There is a row for the name of the project leader. This row is defined as "Dropdown list" with the setting…
missing source appearing on Dashboard
A dashboard that I use daily now appears with "missing source" in a number of places and I have double checked the source is not missing and I am the owner of the dashboard and the source as they appear in the same workspace?! This issue appears since the latest relaese! Has anyone else experienced issues since the new…
Project Schedule Baseline - Is History Kept when Re-baselined?
We are using the Project Schedule Baseline functionality, but recently learned that the Schedule can be Reset or Removed. Is there anyway to track how many times a Schedule has been 'Reset' or 'Removed' and baselined again? Our concern is that without the history being tracked on how many times it's been reset, we won't…
Auto Number Greyed Out
I have got several sheets and have been including Auto number for created by, created date. I am trying to add a created date, but the auto number system is greyed out completely on this sheet. I have a form connected to this sheet that I have pushed out to people to log their hours so I do not want to rebuild the sheet.
Creating Automated Emails are specific times
Hello! We've developed a form; our client would like to see it being sent to them daily at 1100am, and 0300am. Would this be possible? So far, I've gotten this far, but I believe this wouldn't work because Condition two contains "Where created today" submissions that are created at 0235 would not contain yesterday's data…
Decimals keep changing
I have a dropdown column that we used for style numbers. They might be numerical values or alpha/numeric values. The column has always show the value that was selected in the dropdown as it should until the last week or so decimals are being added. No matter how many times I remove the decimals from the column when new…

Popular Tags

Trending in Smartsheet Basics

Data Shuttle Running 5 Hours Early
Based on the log, all my nightly Data Shuttle workflows ran 5 hours earlier than they should have last night. (This may have been happening for a while and I just didn't have reason to notice.) Example: scheduled for 1900 hours, ran at 1400 hours. That's kind of a problem since the data for the day isn't all taken care of…
Automation Not Sending Emails
Hi All, I have a sheet with "Unrestricted" automation settings; however, I'm getting an email with an error message that people aren't receiving alerts due to permission settings. Any ideas?
Has anyone noticed that the source sheet 'link' in an email notification is not a link anymore?
Is this intentional? I can't find any online documentation supporting this change. It appears that the actual 'link' behind the sheet name text has been removed. I'm on board with this because often people click the link and want access when they don't need it. I do still see the link at the very bottom of the email.

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

Watch video

Smartsheet Basics

Discussion List

Categories

Popular Tags