-
How can I hard code a cell based on a trigger?
BLUF: When I create an Invoice, I need the cell-link to my live price data to be severed. I currently have a Price sheet for my products that is updated frequently. I use Control Center to create Projects, which includes an Invoice sheet. I have a dropdown on my invoice sheet to select a product, and then I use Index…
-
Cannot create new Chart from a report
I can create a Chart in Dashboard from sheet well but from Report is not working now. I just try with simple Report (just contain 2 column Primary and Number) but cannot make the chart. Is there any changes recently right, because I haven't worked with Smartsheet dashboard for a long time and I remembered that I could do…
-
Auto Populate Cell Reference by field names
This is going to be hard to explain, but I'm hoping I can do it. I have a sheet named "ProjectSheet". Under Task Column I have multiple "Applications". Under each Application is a Project Stage (Data Gathering, Build, Post Go Live). Under each Stage are two roles (IC, IE) (Top - image) I have a second "Team_Dates" sheet…
-
Use Sheet Summary as cell reference for a different sheet
I'm using salesforce connector to pull my team's hours information in real-time. The Salesforce connector sheet contains sheet summaries that I'd like to use a cell reference for a different sheet. I can't seem to find the best way or formula to do this. I don't want to use a dashboard with report widgets because I prefer…
-
Help with a function to collect data from 2 different sheets based on year date
I need to extract information from 2 different sheets based on the name of the member organisation and the join year (i.e. DD/MM/YYYY). The 2 sheets have the same column titles, but one is for 2024 and another one for 2025. Where organisation joined earlier than 2025, then it needs to fetch the data from the 2024 sheet,…
-
Outlook Email to create new Rows in a Smartsheet
Company uses Bluebeam Revu software to create drafting check sessions (adding notes to PDF's). These session come from the same email address every time and can be automated to be sent to an email. I want to try and get these emails to go to a smartsheet row. what would be the best way to achieve this? My company uses…
-
Revise Filter in Dashboard
I need to revise/expand a filter - the list of items in the filter NOT the filter name - in a dashboard I created. Is this done through the dashboard or through the main data sheet?
-
Cross Sheet Counting
Hello, I have two sheets. One one Sheet I have a column with a drop down of names. I have another column with a dropdown of yes and no. On another sheet, I have all the names as rows and 2 columns. One column is named Video Missed and the other column is named Video Grace. What I need to happen is this: On the first sheet,…
-
Automation to add links in a column in origin sheet from destination sheet.
Hi, I set up an automation to copy a row from someone's intake sheet when they assigned it to my team into my intake sheet. We did this so we didn't miss any of the metadata they are capturing. Can I set up an automation that copies a column that has "DAM Link(s)" from my intake sheet back into the original intake sheet…
-
Can't Find Option to Reference Another Sheet with new AI-enabled design
I was a away from Smartsheets for a few weeks while switching jobs and I can't find some stuff now. A month ago, when doing formulas that had the capability for a cross-sheet reference, Smartsheet would offer you a link to "Reference Another Sheet". Smartsheets a month ago: Now, when I try to use a formula, a pane on the…