-
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…
-
Linking sheets through dropdown box
Is it possible to create a dropdown box which draws it's items from the primary column of another sheet? I am putting together a system for managing the data related to my staff members including workplans, professional development and reporting. On each sheet I would like to be able to ask the staff member to choose their…
-
Update a cell in a column with data from a different columns
Hi, I'm trying to select a range for the completion status and also trying to refer to a different column and get the data updated in a different column. I'm sure I'm doing something wrong here. Please help me! =IF(COUNTIF([Completion Status]3:[Completion Status]38, 0) > 0.5, "Not Completed", "Pending Mgmt Approval",…
-
What sheet types can I use the 'new' DURATION column in?
I NEED to build a timesheet - of some kind - what sheet types, templates can I manipulate that have teh Duration field inbuilt (Gantt sheet is fine, we will just use the grid view). As from what I can see a 'blank template' does not come with Duration as an option. Is this correct? Cheers team!
-
Resource Management: Can we roll up utilization to the group level?
In order for us to justify getting our whole team into Smartsheet, we need to be able to measure utilization. Is there a way to roll up utilization to the group level, in the same way that we can roll up utilization to the user level? Essentially, the goal is to know how much our utilization for a group is for a specific…
-
Trying to create an IF THEN function in smartsheet
My example is to select an material size value based on the material. Something like this: If [cell1]="4X8 Sheet" then [cell2]=32, if [cell1]="4X12 Sheet" then [cell2]=48, etc, etc. I have a dropdown list in the materials column to restrict the set of possible materials. Subsequently, I would like to take those values to…
