-
Suggested Sheets - Update more frequently or in real tme
I notice when I update a sheet, and it appears on my suggested sheet, the preview is not updated. I was told that only occasional screen grabs are taken, and it looks like my sheet is not current, when in fact, it is, giving me problems with the boss.😫 I think the suggested sheets should be updated as well, in real time,…
-
Conditional Formatting in a Report
Is it possible to include Conditional Formatting in a Report? I see discussion on this topic from a few years back, wondering if there has been an update or an easy work-around to include Conditional Formatting in Reports. Thanks!
-
Cell values automatically reverting to previous values. Changes won't save.
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…
-
Using Zapier to update a Form Sheet
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…
-
Sheet Banners
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…
-
Unable to change the start date in a project plan
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…
-
Freezing top row OR colour the header row
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?
-
Form Submission Date Requirements
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…
-
Need a column formula to pull balance from last row
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…
-
move workflow stopped because of system column
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…
