-
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 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…
-
Allow linked cells to trigger workflows
Just as the title says. It's really frustrating when you want linked cells to trigger a workflow but you can't.
-
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 ?
-
Rolling budget/spend tracker
I have a bit of quandary with a recurring task, wherein I am tracking weekly budget allocations and tracking what is NOT spent. Currently, I have a basic sheet where my contractors/vendors upload a patient record, which is just a sign-in sheet, and I manually count the hours used. Each of these sheets represents a maximum…
-
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
-
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…
-
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.