I have two cases where I need a formula to work for me The first one is easy. I have two columns - Delivery Date and Delivery Date (2). I want Delivery Date (2) to automatically put the same date that is in Delivery Date in the corresponding cell. I tried =[Delivery Date]1 but I get an error that says #number expected.…
We recently learned the hard way that there is a limit to how many sheets a report can access! We use the report feature to create individual task lists throughout our company. Each task list searches all sheets for names in an Assigned To column and refines the search looking for a value of "Needs Action" in the Status…
Please send me an email if you would like to be added to the workspace. kriswalsh@gmail.com I love Smartsheet's native symbols and use them all the time. That being said, there are times when I wish I had more options or flexibility with them. I am sharing the following with the hope that: 1. Someone finds it useful. 2.…
Is there a way to have a smartsheet highlight only those changes that have been made in the last n hours? I look for changes to one of our smartsheets every morning and copy them to another file. We have yellow change highlights turned on but I'm finding that they can remain there for days, making it hard to see only…
Hi, I'm trying to create a web form using a Smartsheet with about 30 questions in it, and I want to add in check boxes so that the user can answer a question Yes or No. However, the only way I can think to do this is to create the question as a column, and then create a seperate Yes and a seperate No column to give me the…
I have created a sheet for registrations and only want to add new registrations from an existing spreadsheet. How do I cut or copy and paste the new rows without importing the entire Excel spreadsheet? I only need to add the new information.
Back with (what I believe to be) another obscure question that I don't know how to search for nor find an answer to. I'm attempting to work around the issue of not being able to have more than two dates in a row - we run news stories to multiple audiences so would prefer to have one row for each story, with up to ~10 date…
I would like to be able to publish any rows that have recieved new comments over the past 7 days along with what those comments are. Is that possible?
Hi all, can I suggest that as there are lots of new users to the community since it was launched only a few months ago, that existing and new members add a little detail about themselves? That extra info should make it easier to see the context in which a question is being framed, so the answer is more appropriate?…
We have a report that is populated when a cell is checked off from a tracking list. I would like to send an alert to co-worker when a new row is added to the report.