-
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…
-
Stellen Sie sich vor und lernen Sie Ihre Kollegen kennen!
Hallo, lernen Sie andere Mitglieder der Community kennen und nehmen Sie sich die Zeit, sich unten in den Kommentaren vorzustellen. Ihnen fehlen die Worte und Sie brauchen ein wenig Inspiration? Erzählen Sie uns, woher Sie kommen, welchen Beruf Sie ausüben, wie Sie Smartsheet nutzen oder nutzen möchten und den ein oder…
-
Why can I group but cannot summarize the same field on a report?
I'm not sure what is different about this data sheet. I can 'group' my report by industry vertical; however, when I try to summarize to show a count by Industry Vertical that item will not show in my drop-down in the Summary. I thought perhaps it was because Industry was multi-select, but I changed it, refreshed, and still…
-
Standard Deviation uptick/downtick
I know standard deviation is calculated between 0 to infinity, however, I'm wondering if anybody has a method for inverting the standard deviation to negative if the deviation goes from bigger number to smaller number. In this case, 4/17/24 deviation would be -707%, as compared to 707% I am using STDEVS(COLLECT() based on…
-
Index Match returning incorrect information
I have a smartsheet with trade numbers and I want to pull in the invoice number, invoice due date and invoice amount for the invoices tied to a specific trade number. I had it working correctly but then lost the formulas when I ran out of rows carrying the formula and now I can't get it to work right. Each week I get a new…
-
Is there a way to see if my sheet is being referenced?
I have a sheet I would like to delete but I want to make sure it is not being referenced or being pulled into a dashboard. Can I do that?
-
Due Date alert
Is there a way to alert a user that he has a due date approaching either through the native app or slack? bob
-
Workflow not triggering emails for multiple rows
Hello, I have a grid that I am using to trigger emailing forms to other parties to collect data. I am using a Y/N field and a workflow to trigger the email. When "No" or "blank", nothing happens. When moved to "Yes", the workflow grabs a link from another cell and sends the email with the link to the form. This works fine…
-
#Divide by Zero Error
Hello, It's been awhile since i wrote a big formula. I just need some guidance on getting my formula to return to 0 if there is no data to populate a value. As you can see i have some other IFERROR logic in my formula but for the overall sum I cannot for the life of me figure this one out. =SUMIFS({1st Reply Duration},…
-
Formula Needed!
Hi! I am needing a formula that will count the number of occurrences month to date of a specific data point. I am working on a dashboard for complaints and I am wanting to have a formula on my master sheet that will calculate the number of regulatory complaints we have received month to date that will update with new…