Formulas
Discussion List
- I've created the following cross sheet CountIfs formula: =COUNTIFS({Hutto NA Status}, "Done", {Hutto NA Owner}, [Primary Column]15, {Hutto NA Date}, >TODAY(-7)) Each segment works perfectly on its own…
- I'm hoping someone in the community can help me understand the business logic behind the way durations are calculated over weekends in Smartsheet. For context, my sheet has out-of-box settings for wor…
- Hi I don't seem to be able to affix any text to =PARENT()? I want to have each of 6 child rows as: =PARENT().01 =PARENT().02 =PARENT().03 =PARENT().04 =PARENT().05 =PARENT().06 Any thoughts? Thanks Ch…
- I am having issues with a formula that I try an use to count dates in a column that are less than the present day. With a modification the formula works just fine count the number of dates within the …
- I want to be able to see the count of Projects that are assigned to a specific person in one column and have a status of complete in another column. Not sure what I'm doing wrong? =COUNTIF({Master Tas…
- Hi everyone, I encounter one issue creating formula and linking between two different sheets. I don't know which formula to use but let me share with you what I have done and if you all have a solutio…
- 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 intermitte…
- Good morning Smart Sheet community. I have been tasked to create a commission tracking smart sheet for our sales team. If you have a pre-fab sheet(s), and willing to share, I would be forever grateful…
- I am needing to calculate total square footage, and if that total is less than 2, I need it to round up to 2. THEN multiply that # by a quantity cell See that attached screenshot... Upper 1 W x Upper …