-
What formula can I use to count both the blank spaces of a column and the data from another column?
I want to count the blank spaces of a column titled "completed" where the cells are either blank or have "yes" on them, while at the same time counting the cells of another column in which the cells are blank, "enrolled" and "waitlisted"
-
How do I make a column formula that automatically checks the box if another column contains 1.
I am trying to make a checkbox column automatically check its box if the column1 contains 1. It may be equal to one but in some cases, it could be 1 high or 1 low. How can I check to see if the cell in column 1 of the same row contains 1. I have tried =CONTAINS(1, column1@row), but the boxes aren't checking.
-
Parent Child Conditional Formatting
Hi, I would like conditional formatting to automatically apply to all child rows of a formatted parent row. Is that possible? If yes, how do I set that up? Example: Conditional Formatting turns the parent row row yellow/with blue font if the parent row contains the word Mailing. Child Rows are named Wave 1, Wave 2, Wave 3…
-
Formatting on Smartsheet workflow notification
How to make formatting using HTML tag or using CSS for workflow notification (for Alerts and Approval Request). Its very useful for and impressive for user attraction to highlight the few area for example: A workflow has 6 approval step (3 for verification and 3 for approval). we can highlight the user status of approval…
-
Mark Duplicate value
Hello team can someone suggest a simple way to mark cell (or rows) that one of the columns with Duplicate value thanks in advance oded
-
Child Cell Formatting
I would like for child cells to automatically appear for each new row, and then have an index/match formula be able to populate a column in the parent row from those child rows. For example: New air freight request- 5 child rows with default values of the 5 carriers pop up (can't do a dropdown, I need to track the 5…
-
Formatting A Sheet
Hi all! I am back again with another Smartsheet question! This time I'm not certain if what I'm asking for is even possible. I was wondering if it would be possible to format 3 columns to make them smaller and more digestible. At the moment, I have a sheet that displays dates tasks have been completed, the week of that…
-
Taking Average With Grouped Values
Hi all! I am very new to Smartsheet and am trying to come up with a solution regarding taking an average of matching column values. To explain in more detail, I have "Week Of" column and a "Days to Complete" column. I would like to take the average of the "Days to Complete", but only for corresponding weeks. Essentially,…
-
Forms that need to incorporate multiple line entries
We currently use Jotform for some of our forms here and would like to be able to bring more of them over to Smartsheet if possible As you can see from the attached files, the form is set up to add a new line after each previous line is filled in and the 'save' button pressed Are we able to set up a Smartsheet form to…
-
Populating cells in a column with data from cells from a different column on the same row
Hi, I'm currently trying to build a column where if the cells are blank, they are populated with the data in a cell on the same row but obviously in a different column. This sheet is populated by form entries and I'm trying to fill this column without making its field on the form mandatory. Thanks.
