1

Hello all,

I have been pouring through excel and smartsheet help forums for a couple of days now, and I haven't seen my issue asked or addressed so thought I'd ask here. 

I have, in one column called Terms, cells that contains lists of terms and phrases.  For example, one cell contains the following

3

One of the ways, we utilize Smartsheet it is track the publications that come out of research. A few times a year, we are required to report on all publications and they need to be formatted in a specific way. Is there an option to transform a row into a Word friendly version v. the information

1

I've set up a set of three alerts triggered by a date in a column and it's quite lengthy (but works).  I now want to eliminate rekeying it to 15 other sheets within the same workbook by copying the alerts and placing them in the remaining sheets.  Is there a way to paste them into another sheet?

2

I have three "what if" schedules that I'm trying to pull into a single report.  They are simply named Scenario 1, Scenario 2, and Scenario 3.  No matter what order I select them, the resulting report has #3 in first position, #1 in second, and #2 in last.

I did a bulky workaround by adding a Helper

3

I've got formulas in my sheet that calculate due dates that fall on weekends, and I've used conditional formatting to highlight those dates to alert me to those dates that are on Saturdays and Sundays.  Now, I want to move those dates to the Monday next.  Is there a way to automate that?

3

Hello!

The sheet that I am working with is used to track agreements my department works with. Two of the data points (among many) that we capture is the agreement type within a drop-down and the signature date. I would like to capture the total "Amendment"'s from the drop-down list with a signature