-
Reapprove an Update
After submitting a form I trigger "Request an Approval" that has Approve or Decline. If I choose Decline I can trigger "Request an Update" - My question is how do I reapprove that update? I can trigger at a time of day, but I'm trying to trigger this approval by an action so I don't need to delay to process. Nothing I try…
-
Duplicate Values For Columns with Hyperlinked Values
I've found a formula to indicate whether there's a duplicate value in a column, which is great. However, it appears Smartsheet does not recognize any cells that are hyperlinked so the formula treats this as a negative, even if the values are identical. I've noticed other issues related to hyperlinked cell values like when…
-
Start time, end time in the project plan
Hi, There are many situations where start date, end date and duration is not enough and one needs start time, end time as well. Does anybody know way to have Start Time - 12/24 hrs End time - 12/24 hrs Duration - Days/Hours/Mins The requirement is that end time should automatically populate the correct values by referring…
-
Duplicate report data, filtering on reports query
I have a sheets that shows jobs due to go into production, there are however different stages to these jobs, therefore it has the same work order number for each of these stages. When a job reaches a particular status it requires a review by the quality team, I've therefore created a report to show the quality team all the…
-
Card view, have sub-tasks reflect same status as parent
I have a simple tracking sheet. Tasks with status's. I view this sheet in card view typically. The Status column has your standard (backlog, working, in review, closed) values as drop down lists in sheet view, enabling view by status in card view. When there are sub tasks, I'd like for their status to change at the same…
-
IF function question
How would I write an if statement for a symbol column based on what I have in a stage column? Ex. IF Stage column says Complete= blue, If On Hold = red, If any of these: Not Started, Pre-Install QC Survey, Pending Install IH, Pending Install BP, Post-Install QC, Follow-up =green, to show in the Status (symbol) column?
-
Can you assign a random value based on a list?
I am trying to automate the task of assigning a person to an assignment. Users can submit a form, which generates a row on my sheet. The row then has to be manually assigned to someone to complete it. There are no values that can be used to really assign it to one given person- these are submission for setting up new…
-
Count if formula with multiple criteria where a field contains certain text
Hello, I am having trouble writing a formula to count rows. Where row 1 = Yes where row2 does not contain "virtual" or "needed" (these single words are fragments of the selection in the drop-down list). This formula is on one sheet and counting values from a different sheet. I can get this to work in reverse ie count row 1…
-
Automate Risk Flag
I would like to automate the risk flag if the date is on or after the Target Date. I am new to smartsheet. having trouble with this. thank you
-
Setting up automated "Priority" in Project Portfolio
My company is moving to Smartsheet and we would like to have our "Priority" column automatically populate as Strategic, High, Medium, Low, or Not Prioritized depending on criteria in 2 separate columns (Impact and Urgency). If Impact and Urgency = "High", Priority = "Strategic If Impact = "High" and Urgency = "Medium",…
