-
Restrictions on "Clear Cells" automation?
I want to set up a rule to have a cell contents cleared when the completed date is filled in another cell. I have used similar automation in the past, but when I try this time is does not give me the column of the cell I want to clear as an option to choose when setting up the rule. Are there restrictions on the cell type…
-
Please could someone kindly help fix IF/INDEX/MATCH formula
Hello I need a little help if possible Original Formula: =INDEX({Jira MMP's Validation Results - Jira Status}, MATCH([Req ID]@row, {Jira MMP's Validation Results - MMP ID}, 0)) Which worked perfectly to change the status in sheet 2 to match sheet 1 if REQ ID and MMP ID matched, but this is when there was only a single set…
-
Can't find sheets assigned to new user
hello, Personnel changes. Need to move assets from current user to his/her replacement. 1- Created new user 2- Transferred owner permissions and owned groups to new user 3- Deactivated old user On new user profile, i run "Sheet access report" and see the 2 sheets he/she has inherited. The new user cannot see these nor i…
-
countif
how do I do a total count of PPAP rejected and PPAP approved along with adding blank cells together if the FAI Report or PPAP column says PPAP?
-
Product and Implementation Training Durations?
Hi Community! I found an article that we have 60 days to complete the exam once purchased, but I am unable to find a list of the durations for each of the training paths. For example, the core product training has 15 modules, some are 2hrs, some are 30mins, but I have to click through each of the 15 to then add together…
-
send dashboards via email status update?
This discussion was created from comments split from: FAQs and Guidelines for posting Product Feedback Ideas.
-
Is it possible to figure out which sheet an automated message came from?
Hi all, I have built some rubrics that automatically inform students whether or not they have met the criteria for a badge award. "Yes" gets one email, "No" gets another. The problem is that I cannot find the workflow I set up (it was a while back), and I have to change the wording of the notification. The sheet itself is…
-
HELP! How do I move a form from one Smartsheet to another?
Unfortunately I've created a form against the wrong smartsheet and it took hrs to make, this has then messed up the form its against. Is there an easy way of copying it into another smartsheet and then deleting the form against the wrong sheet?
-
License Tags
Can we have the capability for a System Admin to be notified whenever a user is tagged as licensed or when a licensed user is untagged as licensed.
-
Workflow - Generate Document
Hello everyone, I am using the 30-day trial in Smartsheet to convince my bosses to implement this program. I am setting up a simple sheet that our service techs fill out after each job they complete. When the form is completed I want the Workflow to generate a PDF document that I have all mapped out. But, for some reason,…