Hello everyone! New to the community, but loving how detailed Smartsheet is! I am setting up alerts to trigger when a due date is approaching, 6 months, 3 months and 1 month to staff whose certifications will expire on that date. I would love for the alert to trigger an additional action, to check a box in the cell…
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…
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,…
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…
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
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.
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…
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…
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…
Please please please make it possible to use formulas in contact columns! :)