-
Is there a way to calculate age in years and months (4 years, 11 months for example)?
I have been able to calculate the age in years, but so far have not seen any other support questions to answer whether this can be done in years and months. Appreciate any help towards a solution, thank you!
-
Department capacity reporting
Hello, I'm trying to find an effective way to report capacity by department in a dashboard. For example, I have multiple departments working on several projects with different start/end months. What would be the best way to report on this in a dashboard?
-
Countifs Question
Greetings! How do I use the countifs formula to count if area =1, category 1 = x, and Date range is April? For the example below the value generated by the formula should be 1. How would I do the same but date range is all of April up to "today"?
-
Bounceback / incorrect email address validation
We use Smartsheet as a contract management tool and have alerts setup to send a notice to requesters / stakeholders when contracts are close to expiration. Unless we go through and manually update / check all of the line items, there's no way for us to know if the alert has been received or if it's bounced back / the…
-
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?