Product questions?
Ask it here! The community's got your back.

Smartsheet Basics

Ask questions about the core Smartsheet application: Sheets, Forms, Reports, Dashboards, and more.

Looking to filter for unique value and summarize amounts
Hi, I am not sure this can be done with Smartsheet. In the screenshot, I need to retrieve unique values in the project# column and summarize the values for each project. The bottom part in yellow shows the result I am looking for. Any help would be greatly appreciated! Thierry
IF(AND) can't seem to sort out the order
I've read, reread and reread again a number of posts/articles about IF(AND) expressions but for some reason it's just not getting through my thick head and I think my mysql expressions aren't letting me mentally work this out. This is the specific expression I've been trying to sort out - this is unparsable…
Enhancement Request: Allow Excel import without formatting
I would like to be able to import an Excel file without formatting. Use Case: I have a customer using an (older?) ERP. The ERP can export to Excel. After row 99 of data, the Excel file changes format. They probably thought that was a feature. I'd like to import the Excel file to Smartsheet without formatting to avoid extra…
Sales/Support Hours
I am growing increasingly frustrated with not being able to get in touch with help early in the morning (east coast). What are the hours that sales and support work? I can't find it posted on the website anywhere. Having to wait until midday to get a hold of anyone is really a pain and causing delays for my organization.
COUNTIS
I have a sheet with a lot of data on it and I am wanting to get a count of the number of jobs that have been completed after a certain date. I have managed to create the formula below which allows me to get a count of the full sheet =COUNTIFS({QinetiQ Actual Completion Date}, >=$[Start Date]$3, {QinetiQ Actual Completion…
Percentage completion with limiting value (dropped down list)
I am a new user of SmartSheet. I added a column in SmartSheet called Percentage Completion. And, I would like to limit the input to: - 0.00 (0%) - 0.25 (25%) - 0.50 (50%) - 0.75 (75%) -1.00 (100%) Then, I chose dropped down list for this column. However, this column was excluded in the pull down list of option (% complete…
Column showing who approved the approval request?
We have an approval process that allows multiple people to approve an approval request. Is there a way that I can have a column show who was the approver? Right now we have to right click to view cell history to see who the approver is.
Error Message: Maximum Number of Computers - What Now?
Does anyone know about this error message or what to do about it? The maximum number of computers that are monitoring the device has been exceeded. Polling to the device will be stopped. To restart polling, set in the [Configuration] menu again after a moment.
Not receiving notifications
Hello all... I am fairly new to Smartsheet and this Community but have come across my 1st issue. I have created a Smartsheet where multiple users will be entering data for items to be purchased through our Purchasing Dept. I have created a formula where, when the "Ordered By:" and "Ordered Date" are populated, the "Status…
Agendas in the meeting templates
Hi - I'm working in the agendas, and in the template, there's upcoming, past and new agenda submissions. In the dashboard, it has previous agendas and upcoming agendas... How do I get that to update to the next agenda? The first meeting I did is over, do I have to make a new form for the next meeting and link it, or can I…

Popular Tags

Trending in Smartsheet Basics

Schedule Dates Minus 2 days Except Weekends
I'm trying to figure out a formula. I have a customer that requires a 2 day notice that my crew will be onsite to work. I have an automation set up to remind me to send the store an email 2 days prior. In my "Notify Store" column I have a formula for schedule date -2, but I don't know how to exclude weekends so that the…
PDF Generator Automation Attachments
I've set up an automation to generate a PDF when a row of data is submitted via a form. I have another automation to generate the PDF again each time data in the row changes. I am finding that the subsequent PDF attachment is replacing the first in attachments. Is there a way to have the subsequent PDF added as an…
Inform team on general sheet
Hi, Is there a way, now on a row but sheet level to inform the team whom the sheet has been shared with about modifications done to said sheet. E.g.; I have added locations to a locations column and would like to inform all sheet collaborators on it. Additionally I would like to ask some if moving forward to make a form on…

Help shape the future of Smartsheet.
Share your ideas and feature requests.

Watch video

Smartsheet Basics

Discussion List

Categories

Popular Tags