Formulas
Discussion List
- Hello, I have been trying to write a formula to pull the averages of numbers in each column by Leader into a separate sheet but the only formula I could find that can calculate this is working, but pu…
- This discussion has been merged.
- A quick background of the build. I am building a sheet that show an "Activity" and its "Date to be Completed by", along with other columns but for this question they don't affect anything. I have a bu…
- A sheet has task start and end dates for various product tasks. The products and tasks are listed in a separate project task lookup sheet. The Task End Date is calculated as x days from the Task Start…
- My sheet is setup with the following levels with how tasks are nested - see screenshot. In the card view, I want the lanes to be the Project Setup level tasks. I have a column formula where I am extra…
- I am tasked with collecting labor rates per employee, but the labor rates change based on the dates posted. For instance, I have old labor rates applied to dates older than December 1st 2023. We recen…
- Hi there, I need some help regarding formulas in Smartsheet. I have a raw data entry sheet, where I am entering the number of Work orders my production team is working for the day. I am trying to find…
- Hi there -- I have a sheet that does not use hierarchy, but does have a main row with related rows under it. The main row has a milestone "Primary" and the subsequent rows have Milestone 1, Milestone …
- Hi Community! Hoping one of you might know what I'm doing wrong here. I'm trying to bring data from my source sheet (a list of requests) into a target sheet (list of placements). I've created a refere…
- Hi Community, I am not sure what formula or combination of formulas to use for the below example: I have a list of Spring products, each product is sorted into a type, and a similar list for Fall prod…