Hi, I am trying to use countifs by referencing another sheet. Here's what/how I am trying to create a report from another smartsheet:
I am trying to count the different type of Tickets for each of my developers. For example, for David I want to count how many Problem ticket has been assigned to him
Hi! I love Smartsheet but I can't seem to find a way to do the following:
After a user submits a Smartsheet web form entry to populate my sheet with data, I'd like to embed a hyperlink into both (if possible) the response and email confirmation so that the user is directed to a web page on my site
Hi, Community! I am wondering if anyone else is using SmartSheet for an institutional planning calendar. I chose a template of project with gantt. Most of the tasks on the calendar, however, are annual, bi-annual, semi-annual, etc. I am trying to figure out the best way to handle that. Would I only
Have a folder with 15 sheets, reports and dashboards used as a template folder. Titles include (Clear) as a generic placeholder in the folder and used in the 15. When a new project is started, we "Save As New" that folder, replace (Clear), with the project folder name and do so for each associated
I'm currently using a formula to INDEX my sheet and pick up the smallest date in a column, and then display the 4 smallest (or soonest) dates in that column to pull into my dashboard. The formula is as follows:
=INDEX([Project Name]:[Status], MATCH(SMALL([Next Milestone Date]:[Next Milestone
When dragging the email from my Outlook window to Smartsheet in Google Chrome it removes the file from my Outlook entirely and the email is gone.
I tested this in MS Edge and confirmed it does not happen when using Edge; the file copies and uploads to Smartsheet without deleting it from Outlook.
So I've had a problem with no "resource view by project" button.
I'm a proposal writer working on a Growth Operations team. I've been working with our Strategic and Business Performance Group to incorporate more Smartsheet into our operations.
I've been entered as a system
I am using the following formula to identify duplicate invoice #s in a spreadsheet. I've noticed that the formula does not work when the invoice # starts with a zero. It works for all other formats: text, numbers (without leading zeroes), dates. The column property is set to text/number. What could