-
Flag By Issue Status Formlua
This seems so basic, but I cant get this formula to work. I have a flag colum that I want the flag to be 'flagged' if the Issue status column has an issue listed as "Open" This is what I'm using and getting an unparseable =IF(Issue@row = Open, 1,0) Thanks in advance!
-
Issue in sending update request
Dear Sir, My company has a Business account with Smartsheet with 3 licensed users. The other employees of the company also working with a smartsheet account as a free user. Earlier they are able to send update request from their smartsheet and get updates from other users of smartsheet. But now after updation of software…
-
Disable email notifications from Update Requests
I am the owner of all sheets for my company, and I regularily send out update requests to confirm if tasks are completed. It was brought to my attention that the task managers to whom I am sending the requests are receiving "Update Confirmation" emails upon submitting the Update Request Form. I am also receiving the…
-
Update Request Automation
Hi there, I need help please, is it possible to edit a update request? When the update request automation is send, is it possible to only select some of the columns so that the sales personnel not get the whole line's columns but just 5 or 6 of them that they must update? Hope you understand? I know if you send an…
-
Update a line via form without rights to view the sheet
Hi, I have a list of adresses and would like to send an update request but without giving this person the rights to view the whole sheet. Any ideas how to make this? Thanks, Joachim
-
How to Set My Weekly Update Request Form to Blank Cells before the Weekly Update Request?
Hello, I would like for this form to go completely blank on ALL cell-rows before the update request gets sent to the collaborators (not licensed users) every week. I already have the update request set to send every Friday at 9AM to request the form to be filled by the list of collaborators. I just want to make sure the…
-
Text in Update Request splits in the middle of a sentence and moves to new row.
Hello: I have an Update Request that contains a message. For some reason, SmartSheet is causing a break in the text and moving a portion of a sentence to a new row. No matter what I do with it, I can't get it to flow the way it should in a paragraph. I even created a second Update Request, retyped of the verbiage and it…
-
Can you sort rows or filter in the iOS app?
I am trying to sort a list from ascending to descending in the iOS app. Or filter out values less than a certain number. Seems like this would be very standard functionality for a spreadsheet. Am I missing something? Any help would be greatly appreciated.
-
find and replace text in an already created update request.
I have update requests set for each employee's annual review. I would like to change one bit of text in the preformatted email. Is there a way to do this? Specifically, the line reads: Contact Mary Beth or Jesse. I would like to remove 'Mary Beth or' Is there a way to do this without opening each request individually and…
-
Card View multiple perspectives
The Card View is awesome, creates verticle swimlanes for each value in a drop-down field. I'm wondering if there is a way to add a second perspective to the Card View from a second drop-down field. The secondary values would render as horizontal sections. For example, the verticle swimlanes might be departments, but the…