-
Workload over Calendar Duration
I am very new to Smartsheets and am in process of educating myself on the product to help develop some staffing workload tools on a project basis over time. The goal is to help us analyze how employees are allocated on a project over a calender timeline. For example, we use project milestone deadlines to break up a project…
-
IF & ISBlank Function
I am trying to test whether or not the score inputted is greater than 80 or less than 80. If the score is greater than 80 , I would like my status column to populate with a string labeled "Passed". If the score is less than 80 I would like my status column to populate with a string labeled "Failed". Heres the issue, I am…
-
Alert Email Triggers a Checkbox
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…
-
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…