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
Formulas and Functions31Actual Goodfella
I have been using smartsheet for several years, and I would love to see on calendar view a weather icon for, al least, one week.
Just like Microsoft Calendar.
My projects depends on weather, so its pretty important knowing the forecast.
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 smarts…
Using Smartsheet41Bharti Sharma
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 Co…
Archived 2016 Posts304Brittany Lambertus
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…
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?
Using Smartsheet21Joachim Mund
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 reque…
Formulas and Functions51YM_Nor Cal Moving Services
I heard in an ENGAGE 2018 video on alerts is that you can set an alert to request approval based on the values of one of the cells in the row. You can choose a column with drop-down properties to indicate that the alert was Submitted, Decl…
Formulas and Functions386aschneiderheinze74206
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 …
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 …
Archived 2016 Posts145Jerry Darko
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 …
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…
Archived 2016 Posts173Chris Mast
Hi. I'm looking for help troubleshooting an issue I"m having with Automation in smartsheet.
I set up a recurring request for updates to run each Friday at 8:00 AM PST to all Assigned To users in the sheet.
The problem I'm having i…
Using Smartsheet41Sandra Dye
Been trying to look for my solution here, but i can't seem to find it. Hopefully someone can help me.
I have a supplier approval database with supplier info, several checkboxes for required docs, etc.
Also have an approval colum…
Formulas and Functions11Jose da Silva
Can''t find an answer to this. I need people to be able to respond to update requests and enter info there, BUT NOT enter anything at the sheet level. Can a viewer do this?
Wondering if anybody encountered the same situation here.
I have a very simple mechanical drawing approval workflow that works fine if the approver only click on "Approve" or "Decline" button.
The approval column w…
I know you can create a sheet by importing a document into SmartSheet and having it auto-create around the information; however, how do you continue this? IE You take a sheet from Excel, that will continue to be used, and import it into S…
Formulas and Functions53MikeCorvin
Not sure if what I'd like to do is possible in SMARTsheet, but here goes...
I'm working on a SMARTsheet that receives data adds and modifications from SMARTforms and autoupdate email requests. There will…
Archived 2015 Posts971Evan Meyers
It would be really great to have more color options for formatting our Smartsheets. Having a color picker that presents a broader range of colors or allows us to enter Hex codes or RGB codes would be a really helpful enhancement as some of…
Archived 2017 Posts43Mike Wilday
With the recent (Sept 19, 2019) update, non-licensed users no longer have the ability to update their Report Builder within SmartSheet. This poses a significant problem for my company, as we have multiple licensed users and ~100 (non-lice…
Hi I would like to include comments and attachments fields in my update request as i would like these fields updating, but I do not want the receiver of the update request to be able to see previous comments or current attachments. Is this…
Am I being dense? I can see ways to automate a reminder based on conditions, but in a sheet with multiple submissions from one person, if I want to remind them ONLY if I haven’t received a recent update, I can’t say “don’t send if.” ?
I have a form that is use to submit travel requests. I would like to set-up an auto-field that captures who the form was "created by", rather than having them enter their name into the "contact list". I was hoping to us…
Formulas and Functions41hletson
I have a form where my customer can request certification documentation. The form logs in a Smartsheet for tracking requests. The automation sends an update alert out to my team, requesting a response. When they respond to the update alert…
One of the features of forms that I use frequently is the ability to add a "hidden field" with a value that is written to the sheet upon submission. This is really useful when performing a simple evaluation of form submission co…
Using Smartsheet21Doug Winenger
I am using Smartsheet for a lot of different applications within our organization. I have a number of outstanding update requests - across a dozen sheets - but have no easy way of seeing the status of them all at once. Is there an easy w…
Archived 2015 Posts71Tim Williamson
Are we able to lock comments on rows or sheets do that they stay to the top?
HELP / VERY ANNOYED
Today my Business Administrator was going about her business and Smartsheets without any communication to me as admin and paid user license or prior notice, seems to think it was ok to commercialise the update request …
The "Open To Today's Date" feature works for the sheet owner/admin, but if the user just has "editing" or "viewing" rights, they are forced to scroll on the x-axis to get to today's date.
Is there a way to ma…
Using Smartsheet11Chrissie Smith
I am trying to figure out how to auto fill information into my sheet, when I check a box in a different sheet. I am keeping track of different invoices and sponsorships in the original sheet.
When I check a box in the column &…
API & Developers51Olivia.Intern