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.

If then formula to check a box when another column contains text
Hi, Can anyone help me with a If then formula? I have been trying several things and haven't had any luck. I need to write an IF then formula for the below: Column A checkbox is checked when Column B contains text (any text). Does anyone know what this formula would be? Thank you, Crystal
Send row function not working for shared sheet
The send row function is no longer working for a user I share a sheet with. The function is grayed out. and returns a message to upgrade to a paid level. I'm on a licensed business plan. It has been working for month, until today.
Subtasks in Card View to show on Grid View
Hello, I created subtasks on my card view and for a while, they showed in my grid view. Now they don't, tho I can see from the row counts that they are there. There is a plus/minus sign on the rows, but it just toggles back and forth without showing the lines. Thank you
Unable to view forms from preview.
Created several forms and last week I was able to preview. I can no longer preview and when I sent the link to a coworker they had the same issue.
Cc others in request update
Hi Can anyone provide some insight regarding Cc others when I send a request update. I would like others to have a preview.
Formula Only Column
Hello! Can the entire column have the formula in each cell without it marking it as a new row? Status Column = Drop-down Column State Column = Symbols Column (with red/yellow/green symbols) Goal: State column automatically updates based on Status column. Example: If Status column says “sent for approval” then the my State…
Single or multiple project Status Widget
Hi, I would like to see a progress report as shown in the attached image of individual project sheets or across many project sheets. Functionality would include clicking the numbers to see the rows and take action on them.
Row Locking Now Requires Paid User
For the past 3 years I have had free license users managing a sheet and locking rows. Seems as of yesterday they lost the ability to lock rows and the annotation states that they need to upgrade to a paid user in order to do so. Can someone confirm this is the new normal? Maybe provide a link to a announcement that states…
Update Requests
HELP / VERY ANNOYED Today my Business Administrator was going about her business and Smartsheets without any communication to me as admin and paid user license or prior notice, seems to think it was ok to commercialise the update request function and convert a free log in / collaborator into a paying account user. They are…
Send Row function not working
I understand on 9/19/2019 Smartsheet changed unlicensed user functionality. The send row function is now no longer working for a two users I share a sheet with. The function is grayed out and returns a message to upgrade to a paid level. They cannot cannot perform their job duties without this function. The UNM HSC should…

Popular Tags

Trending in Smartsheet Basics

Is there a way to have a form update existing information?
We are conducting an audit of our I-9s. In order to do so, we have pulled an active list of all of our employees (EEs). These EE names are already on the sheet. In order to effectively complete the audit, there are specific things we need to check for based on the expiration date of the I-9 document that we have on file.…
Pulling info from Reference Sheet based on Date
Hello, I am trying to pull the information I need based on a date on the referenced sheet. Without this criteria the formula works great. this one criteria is not working. I created a helper column on each sheet. on the reference sheet is a formula to calculate the month number for that row, and then on main sheet is a…
Need help with Data/Chart Widget
I am working on a dashboard with various data points and had zero issues until I started the most recent widget. I am pulling from a simple report that has a list of staff members and their assigned work spaces. I keep getting an error that says the data cannot be charted… What is the limitation here? I made 4 other…

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

Watch video

Smartsheet Basics

Discussion List

Categories

Popular Tags