Trending in Smartsheet Basics
Help translating Excel formula to Smartsheet formula
I need some help translating a formula from Excel into something that I could use with Smartsheet. The final formula in Smartsheet would end up being a nested if: If Enterprise 2022 R1, give # of months between GA date and Go-live date, if EDIS 2022 R1, give # of months between EDGA Date and Go-live Date, if these are…
Cross-sheet references maxed out
I'm building a large master reporting sheet that cross references multiple other form response sheets based on a shared "incident number". I have six more columns of data to pull over from another sheet but have maxed out the cross sheet references (100 per sheet!) This master sheet then uses that data to create pdf's. I…
Importing Excel Data without overwriting formula columns.
I have data in Excel that I need to import on a weekly basis into Smartsheet (lets say columns A-F) I would like to have columns (lets say G-H) with formulas. How do I import data each week replacing the previous week's data (only columns A-F) without overwriting the formulas? Is it possible to do this via Datashuttle or…