Welcome to the Smartsheet Forum Archives
The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please
Visit the Current Forums. Archived 2017 Posts
Archives for February 2017
Discussion List
Help with IF/AND formula
Hi--I've been reviewing sample Smartsheet formulas from discussions past, but can't quite get my (relatively simple) formula to work. I'm trying to return a checkbox for a given row (let's say 1) if "Rehab?" column is "Yes" AND "Xtra Cost (cog, rehab, tx, etc.) is blank. I've tried several different formulas, but most…
Can recurring update requests for multiple lines be filtered by complete?
We have a recurring update request sent weekly with all the rows that are assigned to a person (the person is not a licensed user). The person has to scroll through all the rows each time, even if the task is already marked as complete on a prior week. My question is, can the automatic recurring update request only send…
Email to smartsheet for helpdesk
Is it possible to have an email sent to a smartsheet. I want to use smartsheet for helpdesk, however it would be nice if users could send to an email account sometimes besides updating a webform.
Drop Down Notifications
Hello, I would like to create a sheet for employee onboarding. In that sheet I want to have drop downs for supervisor names. I would then want the smartsheet to email the supervisor that was selected. Is there a way I can do this?
IF(AND
In the attached sheet an error is showing in my IF(AND statement? [Current Month Sales] shows $0.00 instead of a "" (Blank cell). Thanks in advance <IFRAME WIDTH=1000 HEIGHT=700 FRAMEBORDER=0 SRC="https://app.smartsheet.com/b/publish?EQBCT=fccbf4d16b7442f9bd0160a985e4e494"></IFRAME>
Using COUNTIF and MONTH() to Find a Specific Date
Hello: For a given set of rows with due dates: 04/03/17 04/28/17 04/03/17 04/03/17 06/01/17 04/03/17 05/17/17 05/17/17 04/28/17 I need a formula that will count up all those due in April. I am working with the following formula, but it is not quite right yet: =COUNTIF(DueDate:DueDate, @cell MONTH(DueDate:DueDate) = 4) Can…
Sharing Sheets with Admins
HI there If i share a sheet with someone and that someone is an Administrator....can he add or remove columns on a sheet? I am seen that he can't. Can somebody give me a good answer on this?
Need to reverse new currency formating
How do I reverse the new currency formating. All our sheets now show the cells formatted as currency are now cluttered with the country prefix. Instead of a simple $ sign it is now CA$. I need it removed in all our sheets or to be able to reformat all currency cells to 2 decimal # in one step!.
Unknown Workspace In Report. Not Showing all Data
So we have a manager here who builds reports for his employees and shares those reports. However, we ran into a peculiar issue yesterday. One of the employees reports stopped showing all data. So the manager shared the report with me (I am admin and owner of all sheets on the report) When I click the report, absolutely no…
Data retrieval
Help - I have deleted data from a sheet and the sheet refreshed unexpectedly when I closed it - can I get the data back?