-
Can you have an Approval Workflow go back into the workflow after a Decline?
Hi! I will try to explain this the best way I can. :) I have a process I need to run through 6 approvers one after another. If one person declines it needs to send an update request to the submitter to ask them to update something. Once that person makes the update I need it to go back to the person that denied it for…
-
"A workflow has become invalid"
"This workflow triggered itself directly or by at least 1 other workflow, which is prevented. Please modify the workflows that are reacting to this one so they don't trigger each other." Greetings all - This may just be one of those "things you can't do in Smartsheet", and I think I've found a work-around, but I wanted to…
-
Recreate a completed task before archiving
Hello! We have a task worksheet that as a task is completed (Done field checked off), the task is archived to another sheet. What we'd like to be able to do is have that same task recreated on a new line before it is archived with the next due date. These are tasks that need to be completed either daily, weekly, or…
-
Adding Cross Reference Formulas
Smartsheet Community: I am not sure what I am doing wrong here, but I am trying to count across multiple sheets when multiple criteria has been met. I think my parenthesis may be incorrectly placed, but Here is my existing formula: =COUNTIFS({Gwen Pas/Fail}, OR(@cell = "Pass", @cell = "Retest Pass")) + COUNTIFS({Rita…
-
New row autofill
I want to autofill new rows with formulas that would execute as data is loaded into certain fields. Specifically, someone uses a form to start a new row. In the form there is a logic option but not a real conditional with a formula. It may not be available in the Form but what about the Sheet? There is languaging about two…
-
Reference column in multiple sheets to look up information
Hi! I've been researching this for quite a while, but it seems I can't find a solution on my own. Hopefully, some of you have encountered the same type of issue, and will be able to point me in the right direction. I'm trying to create multiple sheets to help my team keep track on our projects, and have created a…
-
Formula based on System-Generated Created Time
Is there are formula to bring the time out of the the System-Generated Created Time to e.g. add on 20 min to this and then perform an action? I have an easy sheet which is filled via 2 forms; one form is used to check in, one is for the check out, filling the same sheet. Problem statement: If someone forgot to check out,…
-
Stacked Bar/Column Charts and Opening Smartsheet Item(s)
I have a couple of Stacked Bar/Column Charts and would like to open a Smartsheet item when selecting a Segment of each Bar. Is there a way to achieve this, or do the Graph Widgets [currently] only support 1 item to be opened? Thoughts on a work around?
-
Cells with IF functions somehow linked
I have 2 columns on sheet A, each with a large IF statement. They both look to fields on sheet B (the same sheet but different fields). For some reason if on field updates, it updates the other field. They are not linked or copied in any way. I've manually rewritten each IF statement more than once. No matter what I change…
-
Why is it that when I drag a formula the information I am looking for is not preserved?
Esta es mi función: =COUNTIFS({LAYOUT CHECK FOR DAL Rango 2}, $Date$1, {LAYOUT CHECK FOR DAL Range 5}, "DAL 2", {LAYOUT CHECK FOR DAL Range 6}, "No") Si la arrastro en otros ´10 ítems hacia abajo, se pierde la secuencia lógica, lo subrayado en gris es la columna "Rango" que no respeta Cuando actualizo referencia hace como…
