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.

Calculate Age
=IF(ISDATE(DOB1), IF(MONTH(DOB1) > MONTH(TODAY()), YEAR(TODAY()) - 1 - YEAR(DOB1), IF(MONTH(DOB1) = MONTH(TODAY()), IF(DAY(DOB1) > DAY(TODAY()), YEAR(TODAY()) - 1 - YEAR(DOB1), YEAR(TODAY()) - YEAR(DOB1)), YEAR(TODAY()) - YEAR(DOB1))), "")
Using Reports & Editing Columns with Formulas
I have created some reports. I have a column in the report that it is currently not allowing the report users to edit. There is no protection. I am presuming that it is because there is a formula in the cell. Is there any way to allow report users to edit the formula in the cell. In this report we would occasionally ask…
Filtered Views for External Collaborators
Hello, i am not sure what the best way is to accomplish this. I have a smartsheet that i would like to collaborate with outside vendors. I would like to avoid chopping up the data and giving every vendor their own sheet. I will be adding new data weekly. Update request won't work because they could be getting 20+ lines at…
Revenue Formulas
Hello I need to take our revenue and break it down into revenue per month, and revenue per quarter and return each value into a separate cell. So take extended sell based on month (I have another column on my sheet called Date Shipped) and add it all up into a cell. Same for the quarterly. I would be open to having the…
Resources allocation / staffing at hourly granularity
Hi. we have the need for a tool that will allow us manage short & simple projects (hours/days) for our team. Something like Float.com. As we are using Smartsheet already, i'd prefer to find a solution that utilize SS, instead of bringing to the company another solution. But - I didn't find a way to work on an hourly basis…
Need help with a recurring report formula
Hi. I am new to Smartsheet and it has been a while since I have done alot with formulas in Excel. I am setting up a report tracker for our organization that will have recurring reports due on a weekly, monthly, and quarterly frequency. I need some help with a formula to automatically adjust the next due date so that…
Automatic blank top row
Hello, Currently when I type into the last row of a sheet it adds a new blank row on the bottom of the sheet. Is there a way to basically reverse this so that the row is constantly added to the top of the sheet?
Calendar View
My conditioning format does not show when I view my smart sheet in the "calendar view". Any suggestions?
Having link to Smartsheet on our intranet
Hi all! I work in the Communications department and we keep a tracker of all of the events for the year. It used to be an Excel spreadsheet and we put a link to it on our Intranet page for all staff to access. Now we keep it in Smartsheet, and I've only given access to my team. Is there a way for folks outside my…
No restrict to dropdown values on form
On the sheet, if I dont check on "Restrict to dropdown values only", then I can type a new value into the dropdown column. But on the form, I cannot type a new value, even I choose not to check "Restrict to dropdown values only" on the column properties. Is there any way that I can create a dropdown field on form and still…

Popular Tags

Trending in Smartsheet Basics

Autopopulate an email address with each new row
Hello, Community! I am trying to set up an automation that adds a specific email address to a field with the creation of each new row. It should be very straightforward but does not seem to work consistently. Trigger - when a row is added Condition - if a specific contact info field is blank {{Notify XYZ}} Action - assign…
Filtering out Status based on two criteria - Not working!
Hi, I'm at a loss and could use some guidance please! I'm running a report from my project plan to see Customer Tasks Statues by Phase if status is not "Complete" or "Not Required". The Complete status don't show but the "Not Required" do. I have tried all the options (Is not blank, Is not equal to, does not contain, is…
Percent showing up in thousands
Hello, why is my 32 showing 3,200% instead of 32%

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

Watch video

Smartsheet Basics

Discussion List

Categories

Popular Tags