-
Needing an "If, Than" formula for multiple variables
I am pulling together stats for a project using the JIRA connector and I need to be able to SUM all "Open" issues + "Reviewed" issues into one cell. I have the beginning of the statement and it works just fine, but whatever I tried to add the last part, "Reviewed" I get an unparseable error. Here is what I have:…
-
Sharing Sheet with Filter only
Enhancement Request: Our company needs the ability to share a sheet with two or more providers and due to confidentiality we need that information to be filtered and locked in the filter so they are unable to see the general sheet. But we still need for the provider to be able to make changes to the sheet with their…
-
Enhancement Request: Sights Auto-Refresh
We have created a departmental dashboard and we're displaying it on a 40" LCD. It looks completely awesome and we are now the envy of all other departments... BUT, the screen doesn't automatically refresh. We created a script that automatically refreshes the screen every 5 minutes and that is working to update the data,…
-
How do I link a project worksheet into the row of a separate worksheet?
Hi, I'm new to Smartsheet and hoping to find a solution to the following: How do you link a worksheet to a row of another worksheet? For example, I have a worksheet for my Master Project List that lists about 70 projects. Each project has a separate worksheet for its individual project tasks/deliverables. I am hoping there…
-
Referencing formula for other sheets?
Is it possible to build a formula that references other cells/sheets into a new sheet? I am trying to create a sheet that would sum values from another sheet into a new one to build some stats. Because the source sheet is generated using the SmartSheet/JIRA connector rows are automatically and constantly being added, so I…
-
Automatic Quarterly Reminders?
Hi there! I am building a database to monitor multiple cashflows and am tying to figure out the best way to set up an automatic reminder for the person responsible for each cashflow to update financial information on a quarterly basis. I was thinking of creating reminder date columns (and hiding them) for each quarter. Is…
-
Store cell data on specific date
Hello, I'm needing some help in figuring out if it's possible for smartsheet to pull data to a cell on a specified date. For example I need to hire 5 people for a building opening on 12/1/2018, but they need to be hired 8 weeks prior. What I want to do is have one cell that takes the hired count cell and pull the info on…
-
Salesforce and Smartsheet Integration
Hi Everyone - Have any of you used the new Salesforce/Smartsheet integration with project plans? I see and understand how it can push and pull data as reports between the systems, but I need to figure out how to take a cell in Smartsheet (Due Date or Date Completed for instance) and map that specific cell to a specific…
-
Linking smartsheet cells to Google sheets
Can we link a particular set of cells or values from Smartsheet to a Google sheet? If yes, then how can we do it?
-
Mutiple If's in a statement
Hello, I am trying to created a multiple if Statement. If column1 contains "Milestone 1" show "30% invoiced If column1 contains "Milestone 2" show 80% invoiced If column1 contains "Milestone 2" show 100% invoiced Can someone please help me created this formula?