I run constantly to the same problem and decided to shout out for help. Basically my problem can be defined as cross sheets conditional autofill. My case: Sheet 1 (offers) - sales people add data abou…
Dear all, I did some research about the following topic but somehow got stucked and every helping hand is appreciated. What is the current status: Currently we are using smartsheet (lets call it "proj…
I updated our smartsheet team schedule to grab dates from my department's master schedule. However, the conditional formatting we set up that visually shows us when a project is nearing or past its du…
Hi I tested vlookup function and I created a new sheet .I deleted this new sheet but now in my master sheet it's still outbound to ref unknown sheet. I cannot delete that link...
Hello, Has anyone successfully used dates to pull totals? I'm trying to do the following: Columns: Start Date | End Date | Status 1/2/18 1/10/18 Completed 1/5/18 1/7/18 Completed 1/5/18 Open 2/8/18 2/…
So I have created a Dashboard with Metrics and Graphs only to learn that as the underlying data in the sheet is updated the widgets do not update they are static. Given the number of dashboards to be …
I have a sheet with multiple countif formula referencing data from multiple sheets. From this single sheet, I have created a vital live data dashboard for multiple users to view and make decisions bas…
Hi, I am having problem with a VLOOKUP process. Our current process flow is as follows Import data into a "DataDump" sheet through API, at this point each row of data is assigned a number, matching th…
Is there a way to edit the dates for when to set a notification past 14 days? We are looking at a way that this can be edited when we need notice 3 weeks in advanced or any specific number of days.
