-
Is it possible to subtract a duration from a date which drives the start date
What I am trying to do is Helper - Duration = Actual start date. So, for example: 14Apr2026 - 22d = Actual start date. Is this possible? Note: I need to keep dependencies turned on.
-
Set a value on one sheet if that sheet's row ID exists on another sheet with a certain status
I have Idea IDs that appear on two different sheets (sheet A, sheet B), and I have a column on sheet B called "Update needed?" Sheet A also has an Idea status column. I need a column formula for sheet B's "update needed" to be set to Yes if sheet A's Idea ID=sheet B's Idea ID for that row AND sheet A's status is "Not…
-
Regional date format issue in cross sheet reference
Hi, we use control center to roll out project toolkits, the intake sheet includes a start and end date for contracts. These dates pull through to a metadata sheet then to various other assets in the toolkit. To set up I right click the cell and select 'Link from cell in other sheet' and link to the relevant cell in the…
-
How do I display the username of a modifier of a specific column?
I am attempting to display the username of a specific column using an automation workflow. I want for a user to be able to scan a barcode into column A, and for their credentials and time/ date of the barcode scan to be displayed in the next two columns. However, I want the credentials and time to be displayed of the user…
-
SUMIFS/VALUE
Hello, On sheet A, I have 2 columns (among many others) . Column1 contains a LEFT-formula that returns 3 digits. Column2 contains a LEFT-formula that returns 3 digits plus a hyphen and then 2 more digits. On sheet B I have a SUMIFS formula that references sheet A. If I reference column2, it works. If I reference Column1 it…
-
How to complete a true Dynamic Linkage between Plans at the Milestone Level
I am looking to establish a dynamic link between two project plans. My goal is to surface milestone-level tasks from a Master Plan into a secondary sheet. Specifically, I need to ensure that updates to dates or status in the Master Plan are reflected in the secondary sheet, and I'm curious if Smartsheet can maintain or…
-
Cell Linking
I have a inventory workspace. I am trying to set it up to link a cell on sheet a to a row on sheet b. The purpose is to set it up so that whenever the quantity on sheet A changes (no matter the cell), the quantity adjust on sheet B (for the entire row). Is this possible?
-
Remove links from the entire sheet
I made a copy of a sheet to test something and forgot to uncheck the option to keep the links. Now the Sheet I copied has all of the linked rows and the sheets where the data populates from now show links to the original and to my copy. Is there a way to remove the links from my copy in hopes it removes the links from the…
-
Adding date ranges to column headers
Hello Smartsheet Community, I saw something at the conference in November and I'm having a hard time remembering what it was called so that I can figure out how to use it, I think it was a "series". Here's my problem: I have several sheets that I am using to create "block based" schedules, each block is defined by dates,…
-
Extract Data from a replaced file in the Folder
Hello Team, I am currently using Data Mesh, to get the sheet updates from Sheet 1 (Source) to Sheet 2 (Target). Now, I am having a situation, where Sheet 1 (source) needs to be replaced on daily basis. The data mesh is unable to retrieve the replaced file. What is the solution Smartsheet can offer in this case ?
-
Adding YTD totals without using Sheet Summary fields
I have a sheet the tracks manufacturing operations. Each year, I need to summarize YTD totals from the sheet. This is resulting in many sheet summary fields each year. As time goes on, I will run out of the limit of 200 fields. Is there a way to automate any of this, either with automation or having information go to…
-
Inputting Contacts into Smartsheets
Hi Smartsheet community, question..my Smartsheet account is not allowing me to input contacts of contractors for project into my inspection reports. I have the correct information for each contact (ie. email and phone number). Would this be a restriction out in place on my company’s end or..I need answers. Any feedback…
-
I need to pull certain data from a sheet to another with specific criteria such as (completion 0%)
I am trying to write a formula that allow me to pull certain data from another sheet with completion % 0 and with specific type/name. I need help with the formula
-
Show all files that are pulling information from a file
We want the ability to see (on any file type) what other files are pulling information from the current file we are on to understand the dependency between sheets/dashboards/reports/etc.
-
Seat type report - what is an "edit"?
Hi all, I ran our Seat Type report as part of the true up, and I noticed that a single user has made almost 550,000 edits in Smartsheet in the past 365 days. This is not a power user, the user account doesn't create items. I have 3 other outliers in the 10,000-20,000 range. So now I'm curious, what constitutes an edit in…
-
Automating Email Alerts for Multi-Stage Document Review
Hi, I’m looking to set up email alerts for two stages of a document review. I’ve currently configured IF functions so that, once the ‘Document Received’ checkbox is selected, the status in the ‘Primary Review’ column automatically changes from ‘Not Started’ to ‘In Progress’. Stakeholders then tick off the relevant boxes in…
-
How to pull cell data from one sheet to another based on criteria
I have a sheet that tracks census of sheltered animals and I want to display that census cell in another sheet that matches the room number. I had a formula that pulled that but another admin had accidentally deleted some columns/formulas. In short, I want the data from the census cell to be pulled into another sheet with…
-
Populate a SmartSheet Template from a form entry
Hi all, I have a form where people request a guide be created. Once that submission is complete, I have to take several of those data points and create a workflow template. Is there any way to take the data from a row and map it to the template to create the client specific sheet automatically? I am thinking of something…
-
Project Selector in Dashboard
I have a Portfolio Dashboard, In tht we have multiple domains and each domains have multiple projects. I have created a main Dashboard which is having a link of Portfolio and each domain overview dashboard. I have individual project Dashboard also Now in each domain Dashboard i want to include a project selector and as…
-
Populating data into another sheet when certain criteria is met
I have two sheets that I need to work together - one for project tracking and one for expenses. When I change the "Payment Status" on an activity within my project tracking sheet to "paid", I want specific data from the row of that activity to populate as a new row in my expense sheet. The expense sheet should contain both…