-
Hello from Jo based in Australia
Hi everyone - Looking forward to becoming an active member of this community. My career is in MedTech and new business startups, specifically in Sales Leadership/Management and Business Development. Introduced to Smartsheet 18 months and am keen to transition into PM. Looking forward to learning more and would appreciate…
-
Certified Smartsheet user on the look out
Hey friends, Anyone hiring experienced Smartsheet user, if so let me know! 😁 I've been using Smartsheet for 6 years, it's so much a part of my daily work productivity and I'd like to seek out another opportunity where I could transition my skills and background in program management into. I've gain so much knowledge and…
-
Excel @Text() Functionality in Smartsheet?
Is there a way in Smartsheet to use a formula that gives the same result as using @text() in Excel? I have a spreadsheet that I need to concatenate several fields together and have the field then display as text. Most of what I see now for formulas is to covert from text into formula. But I need to go the other way? Use…
-
Email Notification - Limits to Columns in Message?
Our clinic managers perform a monthly Joint Commission readiness walk-through for each clinic (approx 125). I have built a form for them to document their results for each question - Compliant vs. Non-Compliant. When setting up a email notification to send the results to the regional directors, there seems to be a…
-
Remove or Increase Cross Sheet Reference Limitations
Please consider removing or increasing cross-sheet reference limitations. I recently built a solution that would require me to manage 3-4 sheets each month for monthly audit results tracking from Joint Commission. I spent weeks building and testing and at the end had to add more questions (total of about 125 to the form.…
-
index match quandary
I'm using this formula to return a student specific date from another sheet based on a student code =INDEX({Student Code from info sheet}, [Student Code]@row, {IEP date from info Sheet}) it says #INVALID DATA TYPE I've used this INDEX MATCH and this type of formula before and I'm not sure why its not working
-
Finding 'send' history form a row
Hi - Is there a way to see what was sent when using the function "Send" when selecting a specific row? I see the activity log notes some information, but I don't see this anywhere. Am I missing it? Is it a better practice to always CC myself to keep track of what I am sending? Thanks! SarahB
-
Annual Calendar by Day Template
Hi, We used the Annual Calendar by Day Template and it works great for the current year. However, we want to continue using the sheet in 2019 below the current year. When I copy the rows to below the current calendar, the formula is not easy to update. Row 373 holds the date the year is generated from and starting in the…
-
Removing Unsubscribe Option from Automation E-mails
Hi all, Is it possible to remove/hide the "Unsubscribe" button from automation e-mails? We had a team member accidentally unsubscribe from alerts that were imperative for them to be getting and it rendered the automation workflow disabled. Thank you in advance!
-
What formulas should I use to count two criteria (including from a multiple dropdown option)?
I want to count "Enrolled" from "Case Status" AND "Medicaid" from "Insurance Type." I used the COUNTIF formula, but it seems like Smartsheet isn't counting the Medicaid cell if it's within a cell with multiple criterias selected. Screenshots below: You can see that even though 2 fit the criteria, the sheet summary only…
