-
Can't build an alert - formula-based email not acceptable
Hello community! Anyone have a work-around for this? Here's the situation: I’ve created a vlookup formula in my sheet to obtain an email address from another sheet, and then want to alert someone using the email address result from the formula. When I go to build the condition in the alert (for approval), the alert will…
-
Conditional formatting to alternate shading of rows based on a field
I've created a sheet to track an IRB's review of projects. Each IRB committee member fills out a form as they review each project, then they use the sheet that's populated by the forms when they meet to review multiple projects. I want to make it easy for them to see at a glance what the responses were for each project,…
-
AverageIF help
I need help with an AverageIF formula. SmartSheet support gave me this formula for help: =AVERAGEIF([Column6]1:[Column6]22, >0). Essentially, I want the formula to give me the average of the numbers in the Time-to-Fill (Working Days) column BUT ONLY if they list Human Resources in the Department column. I wrote this…
-
Attach a PDF in a Web Form
is it possible to include a PDF file as attachement in a Web Form? It is necessary to review that document and after fill the web form aout and submit it. I am triying to save time and efort for me and the users. Thank you. RP
-
Can a System Administrator view all sheets in our account?
We are considering moving an existing survey over to Smartsheet. In this survey, leaders of our company share specific comments about their direct reports. Would our System Administrator in IT be able to see the data in this sheet by default? If that is the case we would not be able to make this change.
-
Auto Email Form Responses
I am wanting to have completed forms auto emailed to an email address that will be supplied in one of the fields on the form that is not the submitters email. Does anyone know if there is a way to do this? I didn't know if this could be done via a workflow but essentially I want the nominated email to received a copy of…
-
How is the checkbox function recognised?
I'm trying to output the number of sick-days into a cell using the criteria 'email address' and checkbox ticked as i only want it to recognise the sickdays if checkbox is ticked. Don't really understand how the checkbox is recognized as I am getting a '#invalid operation' =SUMIFS([Is your absence related to a…
-
Can you do if this then that for auto entry from drop down list
I want a column to chnge its value from a drop down list when a criteria is met. What I am after is a column that is titled "ready for invoice" and is a check box. I have another column named "currently assigned to"that shows the seperate departments on an account and it reflects which department is resposible for the…
-
Formulas in Contact Columns
Please please please make it possible to use formulas in contact columns! :)
-
Can approvers of Smartsheet forms be added without giving access to the sheet?
I am creating a form in Smarthsheet that will require two levels of approval is a particular question is answered in a certain way. In the form they manually enter the email address of the people who are required for approval. I am finding that if I do not share the sheet with the person I am seeking approval from I cannot…