Welcome to the Smartsheet Forum Archives
The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please
Visit the Current Forums.
COUNTIF where cell contains checkmark EXAMPLE
Need a 'countif' example, where cell contains a checkmark?
Web Form Reminders for New Request
I want to use the Web Form to collect agenda topics for weekly meetings. I have the form setup but trying to figure out how to send it out as a weekly reminder for people to add their new topics for the next week meeting. Thanks, Kat
Recurring Tasks Set Up
Is there a way to set up a task that happens every quarter or six months without having to enter the task 4 times in each year?
How to display the grandparent task name or value in a cell
Hello, I would like to display the name or value in a cell, please. I could get the parent by: IF(ISNUMBER([Stages Tasks]6), PARENT([Stages Tasks]6), "") but I would like to get the Grandarent instead. Thx for your help.
Changing the Color of a Parent Task Bart in Gantt Chart
Smartsheet, It would be nice to be able to change the color of a parent task bar in the Gantt Chart. What is the reason for not being able to do this? I did find a comment (https://community.smartsheet.com/discussion/cannot-format-milestones-summary-bars) that says if dependecies are turned on, then gray is the default…
Limit Dropdowns Based on Previous Input
Is there a way to create or limit a dropdown based on input from previous field in Web Forms? So if the user chooses makes a selection in Dropdown #1, I want to tailor the options in Dropdown #2. I I know you can do this in Excel, but now sure here. Newbie and looked through community and help --any advice would be…
Relative Dates in Filters
Is it possible to set up a condition in a filter that includes a relative date like "Today" or "Tomorrow"? For instance, I want to only show rows where the Due Date is "Today" but when I come to work tomorrow, will that filter now have yesterday's date in it?
Conditional formatting font color in Card View
Is there any way for font color changes via conditional formatting to be shown on the cards? I have a formula the changes the row's font color red when an end date field is in the past. Unfotunately I can't see these changes in card view, only in grid. Thanks for the help!
I have comments on a sheet that is no longer going to fit with our structure and I would like to move the comments from a row on one sheet to a row on another sheet. Is there any way to move comments from one row to another? Any way to import comments to an existing sheet? I exported the sheet to Excel and the comments are…
Autofill is working on some formulae in a row and not others
We have been using SmartSheet for about 3 years and have recently developed an approach for our project managers using SmartSheet. We are about to roll it out to our staff but have found an intermittent behaviour that is most troubling. Sometimes, just sometimes, when we insert a new row or add a new row at the end of the…