-
Image-Hyperlink
Wondering if there is a way to make an image as a hyperlink (Click on image). I have tested the option of adding image in cell, and also just add hyperlink with text, but I do not see way to actual make the image as a hyperlink. Thanks for any input.
-
Multiply total project cost by percentage to get sale price
Hello! This is my first post, and I know the answer is simple, but here it goes: I want to take a total project cost column and multiply it by a percentage that is inputted into another call, and have the answer populate an "Extended Price" column. Eventually I want to be able to add subtotals and do the same thing, but…
-
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?
-
Export comments based on date criteria with primary as label
Requirement: * 1. Ability to filter comments by date range for export - for example today's comments associated with the rows on a specific report * 2. Ability to display primary field as a label in the exported comments We use smartsheets to manage tickets. When we hold a meeting, the above output would essentially be the…
-
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!
