-
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…
-
Remove Predecessor Link
I accidentally drug a line to link two tasks, they are not dependent on each other. How do I remove the predecessor line?
-
Can I delete rows from Master sheet?
Hello, I have a Master sheet, into which information comes every day via a form. I also have a Wrap Up sheet which pulls specific data from the Master and manipulates them via a formula into a number I need to display. For example, the form populates the Master Sheet with the number of patients on a unit at midnight, the…
-
Sign-in Sheet using Smartsheet & Forms
I have built a sign-in sheet using forms (yay) but am now wondering if there's a way to do the following: We occasionally collect some attendee data that I'd love to have pre-populated so that people can sign in and add in the rest of their information and also sign there. Is there a good way to do this in Smartsheet?…
-
Roll Up Sheet needs daily "activation" to work
Hello, I have a Master Sheet and a Roll Up sheet based on the Master. The Roll Up uses a lot of formulas, including the "TODAY()" function. Apparently, the Roll Up will NOT refresh to reflect the data that came into the Master unless I physically go in to the Roll Up and "activate" it by scrolling around in it and…
-
Using CHILDREN(cell address) as a range in SUMIFS
I am trying to find the total of Task Total Hours only for rows with a tier level of 2 and where % complete = 1. I am writing this in a summary cell in a mini-dashboard that requires me to write the formula in the % Complete column. I am trying to use CHILDREN(cell address) as a range. What I have read leads me to believe…
-
Automated Update Request Form Changes
I have created an automated workflow, using the Request Update step. This automatically creates the form to send to the user to update. I would like to change the way the form appears and allow multiple line entries. When I go into Forms, that form is not there to update. How do I update the automatically generated form?…
-
Sending a Web form weekly basis
Hello, Does anyone know if there is a way to send a web form on a weekly basis? I have attempted to create an auto workflow but am only able to create an update request. The issue with this is it overwrites the content that was in the row as opposed to adding it to a separate line. If anyone has insight into this, please…
-
Interaction with Microsoft Sharepoint
Long story, short as I can make it. I started to create a list of links in Microsoft Sharepoint until I discovered that it seems to be woefully short with sorting, making child entries, etc. In Smartsheet, I am able to accomplish what I am trying to do with ease. Here's my question. Can Smartsheet and Sharepoint interact…
-
% Complete for a row based on 6 columns of check boxes
Hello - I have a task list that has 6 columns - each column has a check box. I am trying to determine a formula to calculate the % complete based on the populated check boxes. Ex: 6 Columns - if 3 columns were checked the % complete would be 50%, if 2 columns were checked then the % would be 33%, etc. can anyone help me?…