I have a very serious concern. I am updating the contacts column to change the contact from Richard to Teresa. However, after about 10-15 minutes Smartsheet automatically reverts to the original contact. This has been happening for a week . I am very concerned because how can I be assured that changes are saved in all my…
As rows get added & cell values change, it would great if we could automatically sort them in the sheets themselves instead of having to set up reports. Adding the ability to do this in a workflow would be a fantastic addition. Right now we have to do it manually.
Hi! I would love some insight on if I can use Zapier integration to update a form sheet. I created a form for new job requisitions. I need to be able to receive updates from our legacy system as the status changes for each job req. Data Shuttle is not an option as the enterprise does not plan to support it. Could Zapier…
I was working on a sheet and before I started I knew it was going to take me all day and I had this thought that I wish I could throw an "Under Construction" Banner accross the top so people knew that the sheet was undergoing some serious changes. I felt like these banners could also communicate other useful notices to…
I am unable to change the stat date in one of my project plans. Usually, when this happens it's because there's a predecessor linked to it, but there isn't one in this case. I also looked at the project settings and there doesn't appear to be any conflict. I'm trying to change the start take for row 47. Is there a setting…
Please add the ability to use more sort levels when sorting sheets and reports. It's pretty easy to run up against the limit of only being able to sort by 3 columns. In my personal experience there are cases I've hit where we would need to use 5 columns to have a sheet or report sorted in the most logical order. I'm sure…
Am I able to freeze row 1 on a sheet so when people fill out the form, the data imports underneath row one? OR Can I change the colours of the header row like I have with row 1?
Is there a way to set a date requirement for a form submission on a Smartsheet? Meaning, I have a Smartsheet that is for event request. There is a form that auto populates this Smartsheet. I want to set it where the submission date must be at least 2 weeks (14 days) prior to the requested event date on the form. Is this…
I have looked at multiple questions and threads on the community and not found an answer that works. I am trying to create a column formula that pulls the [Balance] from the previous row into the current row entry. I was getting a #circular reference error, I tried IFERROR and some recommendations on other posts, but…
Hello I have 2 sheets a master sheet and a sheet that is populated from a form. the first few columns on the master sheet are filled in via form, that data is then used for estimation which is filled into the second form. the data from the first form is added to the data from the second form on the second sheet using…