I'm trying to create a formula that will display the different colored dots in the status bar. I had success at first but one part of the formula isn't working with the others. I need it to display BL…
I'm essentially trying to make a sheet summary formula for how many open cases someone in a contact list has at the moment. I've got it working when I'm looking at the contact list one way, but the us…
I'd like to request Smartsheet look into adding the "auto-refresh" feature, currently only available on Dashboards, to Reports. We use reports to filter columns for individuals in teams that share a s…
Hey Community, Our Support team has been alerted about an error received ("API developer token is invalid") when adding Google Drive attachments to a sheet. This problem has been reported on multiple …
I am trying to setup an automated metrics sheet from many other sheets and I am stuck on the very first "reference another sheet" formula due to the conditions (countifs) that I'm trying to get it to …
Hi all, My team and I currently use Smartsheet to track monthly referral information. At the beginning of each month, we are looking to obtain the number of referrals received for the prior month (ex:…
Disclaimer: I'm a SmartSheet beginner, and only at an amateur level with Excel formulas. I've reviewed quite a few NETDAYS posts on here already and tried variations of the solutions in all, but so fa…
Hello SmartSheet community! I'd like to double check with you if Smartsheets gantt charts has the posibility of displaying multiple dates in one row, I know there's been several posts regarding this t…
In the sheet summary, I am trying to count if the date in the date columns falls within the next 30 days. It's working fine for Date 1 column, but not for Date 2 column (or the copy of date 2 I create…
Is there any capability in Smartsheets similar to this excel screenshot where columns are able to be expanded and collapsed in a grouping using a button? The scenario at hand is supplier contact infor…