-
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.
-
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…
-
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…
-
Automate RYG Ball based on Checkboxes in Other Columns
I need help from the SmartSheet formula masters... I have 10 checkbox columns (checkbox) and I want the RYG ball to automatically change with the following conditions: * 1) "Red" if no checkboxes are checked. * 2) "Yellow" if some checkboxes are checked. * 3) "Green" if all checkboxes are checked. with one exception... if…
-
Smartsheet for Work Order System
Hi everyone, New to Smartsheet - very excited about the capabilities. Wondering if anyone out there is utilizing the system as a Work Order System? We get batch work orders from our hardware's proprietary dashboard system via email (excel). I would like to drop these into Smartsheet - using perhaps the help desk ticket…
-
VLOOKUP, ISNA, IF Statement
Hi! I would like to know is this kind of formula available in smartsheet? =IF(ISNA(VLOOKUP(C2;I:I;1;FALSE));"NO";"YES") In short- If there is the same name in other collumn mark YES Thnak you!
-
Newbie please help - is this possible
Hi there I'm new to smartsheet and I'm wondering if the following is possible... I'd like to have a template waiting in smartsheet. I'd like to setup a Google form, when its populated, it would automatically be forwarded to smartsheet, as it arrives a new sheet is created based on the Template I created previously. I would…
-
Continous Merge (Real-Time)
Hi everyone, I am new to Smarthsheet, and I just figured out how to merge a Smartsheet with a Google Doc and automatically send it out in an email. Do you know if it is possible to do this in real time and not as a semi-batch process? Once a new smartsheet row is added I want it to automatically merge and send via email if…
-
Misaligned Selected Box in Smartsheet - GUI
Hi, I have noticed the following after using smartsheet on Windows7 and IE 9.0. It looks like the selected box is mis-aligned which is offset from the box that youa re typing in. I have to switch to a new sheet and back again for it to disappear, but it eventually comes back. Any help would be much appreciated. Kind…
-
Can anyone tell a new user "How long does it take Smartsheet Support to respond?
I submitted a question early today and have received no response whatsoever. I've tried calling and all I get is they're in a meeting or leave your information. Not the best way to begin a relationship. :-( Thank you in advance