-
Formula for showing subtraction/sum compared to total
Hi there, I'm working on testing quality assurance of products sent to my company. For each row in my Smartsheet represents one product I am testing. Each row requires testing on 160 samples. In my reports I want to show the "Result Summary" column where if there were no nonconformities, then it would show up as "160/160".…
-
Row Copy Automation
I have two sheets - a Checkpoint sheet and a project RAID log. If Action Required is set to YES on the checkpoint sheet, the copy row automation should trigger to copy the row from the checkpoint sheet to the project RAID log. I have hidden columns in both sheets so that they match but only the relevant columns are shown…
-
Can I create automated survey feedback to a user in Smartsheet
I'm new to using Smartsheet and I'm trying to design a survey with automated feedback to the user. I'm wondering if Smartsheet has the capability to do this. Here is an overview of what I'm trying to do. I have created a survey that will be going to out to certain company branches. The survey has 10 sections with a pass/no…
-
Vlookup cell isn't multiplying with another cell.
Hi guys whenever I am trying to multiply my Vlookup cell with another cell it gives a Value error. I have linked web data to other sheets and have a vlookup for specific data in cell D6. In G6 I then want to multiply D6 by a value in F6 using =D6*F6, but a value error occurs. I have also tried copying and pasting the…
-
Can I sent an Alert in a sheet (column) to a Smartsheet Group?
We have a sheet that a "group" works, I want to send an automated email to the "group" that a line has been added. I have created the "group" in Group Management. What would be the best column type/ column properties to use to make this happen?
-
Automated Workflow - Alert Notifications
Happy Friday SMEs! Is there a way to confirm an automated workflow "Alert" actioned properly. For example, when generating an "Update Request", you can validate if/when the request is completed by referencing the toolbar highlighted below --- Is there a similar feature (or mechanism) to track when/if "Alert" workflows are…
-
How to block a cell on formula
Hi, I want to know how can I lock a cell in a spatial working formula. Example: = IF (AND ({PROJECT CASE TEST Rank 7} = January1, {PROJECT CASE TEST Rank 6} = January2), {PROJECT CASE TEST Rank 8} + {PROJECT CASE TEST Rank 9} * January5, "") When I pull the formula left, right or down, the cell formula can't blocked and…
-
Automatic Workflow Email Trigger for Dependency Rows
Do we have the option to send an email alert to the next person in the activity once the prior activity is marked as completed? I tried to do this using the "Request for Update, but this doesn't work. Could you please help?
-
I used automation and move a row and the row disappeared off of my sheet but did not appear on the t
I do not see an error log, additional columns headers were added to the the target sheet but no data ever appeared. how can i find out if there was an error or even see my data? I changed it to a copy so I would not "lose" any more data until I got it figured out.
-
90 Day follow-up alert
Hello All, I am trying to create an automation that notifies me 90 days after the Actual Closed Date so I can do a follow-up. Is there a way to do this or do I need to do a workaround formula that calculates 90 days after the date in that field and then have the alert be once that date is reached to send me something?
