-
Automate RYG balls when a check box is ticked in one colum only out of three columns
I am trying to create a formula that changes the RYG balls to Green if one box is checked out of three columns. Can anyone help?
-
Trying to Sum Rows of linked cells
I'm new to Smartsheet and struggling with a few things, one in particular is wearing me out. I have several rows of linked cells that pull number values from another Sheet. I'm trying to Sum total these linked cells but the basic Sum formula doesn't seem to recognize these numbers. If I remove the Link the Sum formula…
-
Combining COUNTIF and COUNT(CHILDREN) formulas
Is there a way to create a single count formula that will return the number of rows using two criteria? I need the number of rows with column A = Abby and column F = MONTH(@cell) = 2
-
Could somebody please help with formulas and reports
I have created an action date column on all my spreadsheets, I would like this populated by default with today's date. I would then like a report running in the background letting me know if any lines become overdue i.e. in the past - I plan to display this on a large computer screen visible by all users If anyone can…
-
Formula Help Needed
Hi everyone, Need some help. I'm sure this is a simple formula ... but I'm not Excel (or Smartsheets) savvy enough to figure it out. I have a DATE column, and I have a FLAG column. If the date entered in the DATE column is more than 7 days in the past, I want the FLAG to appear in the flag column. If the DATE entered is…
-
COUNTIF using Parent Rows Only
I am trying to come up with a formula that would count only the parents rows.
-
Only show the most recent associated date in a report for a value that appears more than once
We are using smartsheet to track when facilities wihtin the organization are visited. Essentially, we have a form that employees fill out indicating which facility they went to and when they went there. I am have created a report that will show all facilities within the organization that have not been visited in a…
-
Auto Fill Dates
I am trying to have cell automatically fill the following dates: * First day of the current week (i.e Monday) * Last day of the current week (i.e Sunday) * * First day of the next week (i.e Monday) * Last day of the next week (i.e Sunday) * * First day of the previous week (i.e Monday) * Last day of the previous week (i.e…
-
How to Construct a Formula: If Cell is Blank Return Value from Another Cell on Same Row
How is the formula written to do the following? If the cell called "Description" on row 1 is blank, use the contents of the cell called "Keywords" on row 1.
-
Reverse Engineering a Timeline
Is there an easy way to reverse a timeline that was originally based off of a start date, but should be based on the end date? We plan a lot of meetings where the meeting dates are always moving and we want to adjust the way we have our timelines so we can change the meeting date and Smartsheet can fill in the dates of the…