-
How to integrate the top rows from new form entries into the COUNIF formula?
I am trying to lock the first row in my countif formula, but as the form gets new entries and the rows are added to the top, my countif formula changes does not capture the first row.
-
formula that tells me the smallest width measured and the largest
This discussion was created from comments split from: Find Max and Min values in one cell.
-
Find Matching cells between 2 sheets
I need to find cells that match each other on 2 sheets and display them on a 3rd sheet, but the displayed cells have to be in the last 14 days of a date column on one of the original 2 sheets.
-
How do you Reactivate a Workflow upon Declining and Approval on a Form
Can someone please tell me the best way to make updates to a declined form and reactive a workflow when those updates have been made? I appreciate your help! Christi
-
Use Row@row to reference the row above in a column formula
I'm attempting to use Row@row along with an Auto Number column, in a column formula, so I don't have to manually update the formula when rows move within the sheet, but am not having any luck. The formula in the Est. RU Date column is RU Date, if it is populated, otherwise it should take the date in the Est. RD Date column…
-
Formula to check a box or change status of a parent to complete when all the children are complete
Hello. I would like to have a parent status automatically change to Complete when all of the children rows have a status of Complete. I created a couple helper columns to accomplish this and then was planning to use automation for "when the parent-complete box is checked, change the status to Complete". However, something…
-
Exclude blank rows from intra-sheets IF formula
Hello, I am very new to Smartsheet and figuring out how formulas work. I am using this formula to have a checkbox column checked when the values of another column match the ones of another sheet. I realized that in this other sheet that I am comparing it I have blank rows and when this happens the checkbox column is…
-
Exporting Contacts / Editing them / re-Importing
Can this be done as a method to mass-edit Contacts that weren't set up properly from the beginning. We are efforting to make the syntax the same for all contacts and need an easy way to do this. I asked the second part of the question by itself in another post, but if this IS possible, once you import the changes into My…
-
How to get attachment in the Alert Notification
Hello Everyone, I am trying to send the attachment to the other team member, my condition in the sheet is if the person checked the box in the sheet, the manager should receive the notification along with the attachment, which is attached to the row, but in my case, the attachment is not showing in the mail. Please suggest…
-
Why i am getting one combined email when adding multiple entries in a form
Hi Friends Hope you are doing good and staying safe! I am using Automation>Trigger>Alert someone feature to get email notification when user submits the form. I want to get individual email for each entry, however if user submits the form multiple times with different data, i am getting one combined email instead of…