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. Becaus…
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 financia…
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 th…
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…
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 1…
I have a large project sheet with multiple people assigned to various tasks. I want to send out a weekly update request, but don't want to have to select each row for each different user, as these cha…
I would like to be able to use an array formula like Excel has so I can recreate my fee estimate sheets in Smartsheet. It does not appear like Smartsheet can do this. Can you please add this capabili…
How can I get the Sprint name field to pull from Jira to Smartsheets? The Sprint field is not showing up as a field in the Jira + Smartsheets connector for me to sync.