Hello - I am sending out pretty lengthly update request logic emails. I was wondering if there was a way that when the person receives an email they see only a few columns, but when they click the lin…
I am trying to pull contract numbers from an Active Contract file over to a 2nd file using the customer name as the unique identifier which is working just fine via INDEX(MATCH), however, if a custome…
Hey Smartsheets Community! I can't find any information on this so I'm hoping y'all can help! We are making a panel application form and we're attempting to make a form that will fill with pre-arrange…
Hello, Is there a way for me to hide rows if one of the cells says "completed" by using a conditioning format? If that is not possible, is there a formula that I can implement that would get the job d…
Hello. I'm new to formulas and need help. I'm trying to figure out how to get the total % complete for a column of check boxes. We need to know the % complete by milestone (which we figured out) AND t…
I have a daily reports grid and everyone in my team must complete a form everyday. If by 3 on any given day they have yet to do this, I want an email reminder sent to them. Is this possible? Thanks in…
The "Smartsheet Formula Examples" template, while very helpful, appears to have a variety of issues with cell references that have been moved over time. Somewhere around row 26 things start to get wei…
My objective is to return a sum of all 'Work Hours' that are in a department (Wire in this example), that fall within a date range of the 'END' date that Smartsheet is reporting.. This formula returns…
Hi there! I am working to automate the RYGG balls and its like I can get parts of the formula to work separately but not all together. I added a Past Due column to use to try to refer to that indicato…
Hello! I am attempting to create a Smartsheet form. When a user completes the form they need to identify every account that will be impacted by the project associated with that form. How can we includ…