-
Pulling Values from referenced sheet cell, where mutliple values exist in the cell.
Using the following formula to pull values from a source sheet, when it matches a cell in my current sheet. =IFERROR(INDEX(COLLECT({eITCR # (Open)}, {eITCR - Open AI}, HAS([InfoCard Number]@row, @cell )), 1), INDEX(COLLECT({eITCR # (Closed)}, {eITCR - Closed AI}, HAS([InfoCard Number]@row, @cell )), 1)) The issue I have is…
-
Workflow condition
Hi All, We have a workflow that requires approval from HOD followed by approval from CRO. In the normal situation the HOD is different from the CRO and each individual receives the approval notification email. However, in some cases the HOD is the same as the CRO. So he is getting 2 email notifications for approval. We…
-
Column taking up half of the view in a section of the Dashboard.
Can you help me figure out why the % Complete column is taking up half of the view in the ‘At Risk Tasks’ section of the Dashboard? Are there any articles that explain how to modify this?
-
Dates in charts
If I have multiple years of data, with the date format as mm/yy, how can I make that display in the correct order on a chart? I started with mm/dd/yy and then converted with a formula to mm/yy because I couldn't find that format. Now I want to make a stacked bar chart with the dates on the y axis in chronological order.
-
Hide the title bar from emails
For the automated emails, I need this section hidden or smaller. Most of the time, I have to scroll down to even look at one sentence of actual data.
-
Has anyone developed an organization-wide solution for Joint Commissions readiness?
I was asked if I could develop a JC readiness tool for one of our departments, which of course I can with SS :). But a better solution would be to develop an organization-wide solution with department data rolling up to the top, utilizing a consistent look, feel, naming conventions, et al. Just wondering if anyone has…
-
I need technical support
I have a Basic support plan, which is supposed to allow me to create a support case, but the Contact Support page (though it has a link to create a ticket) cyclically sends me to the AI bot that doesn't help. After an hour of frustrating back and forth, it just terminated the chat (though it said it was transferring me to…
-
Resource Manager Reports - date logic capability expansion
Resource Manager Reports need date logic capabilities beyond the standard last week, last month. Flexible logic like "today()- 2 months", or "today() + 6 months" etc. Having to update an existing report and or the resulting data and formulas each month so it displays the information that is needed rather than just enabling…
-
Looking for Guidance on Conducting My First Smartsheet User True‑Up
Hello, I am preparing for my first rue‑up under the User Subscription Model, and I would appreciate insights from those who have already been through this process. A few questions for the group: Do you typically send communications to users whose accounts will be converted to Viewers or have their license status changed?…
-
UPPERCASE and LOWERCASE
It would be ideal to have a drop down select/ format where you can highlight/ select column/ row to be UPPERCASE or LOWERCASE etc. Rather than the function where you need to enter text (which only applies to that instance) the whole is formatted properly (as in Google Docs/ Word/ Excel).