I'd like to merge 2 smart sheets. I have column headers and row info that I would like to add to existing rows on a separate sheet. Is there a way to just add these new columns to the back end of the …
I am working on a formula that will look at a few different cells and make a calculation. I need the formula to look at ETA to Ready = [terminal ETA] + [# of days] The [# of days] is determined by whi…
We monitor the number of requests that come into 3 different Smartsheet forms week over week... i created a dashboard to show the requests within the past 7 days, but i need the rows to tally... even …
Hi, I have a series of standard processes that have the same dependency and predecessor data each time. I have the primary column as a job number, and then a second column with a drop down list of all…
Is there and EOM formula that will use the Month Column instead of manually using the DATE (2019,1,31) format? Excel example: =COUNTIFS(Type of Lead,"Servicing",Date Received,">="&B5,Date Received,"<=…
We have a task sheet that uses 3 checkbox columns (Sent, Received or Done, N/A). We have a formula that counts the number of tasks and how many are completed based on the Received or Done column. We a…
Hi everyone, I need some help with a formula that just doesn't want to work for me. Currently my status column changes according to the {Proof Approval - Kim} column. It works fine (formula shown belo…