Hi all, I'm struggling to think of a way to aggregate data that changes weekly. I will try and describe as best as I can! We have a sheet that financial advisers fill in weekly (separate sheet for eac…
Is there any way to allow only selected cell for updates? Reason being that I would not want other data in the row to be accidently and wrongly updated. Thanks!
Hello Everyone! I am needing help with the SUMIFS formula for cross sheet reference but when I enter multiple criteria, it returns a value of 0. What I am trying to accomplish is a sum for Sheet-2 bas…
Is there any way to copy the contents of a cell into Comments? Or have comments on a specific cell? Or show the value of the last entry in Comments in a cell? Thanks.
Hi there I'm linking cells from numerous sheets to one specific. Most of the cells are containing dates. When linking, I have realised that month and date have switched places. Not all dates/cells, bu…
Is it possible to create a dropdown box which draws it's items from the primary column of another sheet? I am putting together a system for managing the data related to my staff members including work…
I'm trying to figure out the correct formula for counting up the # of entries for a particular location with a "YES" or "NO" data entry for the previous date, TODAY (-1), that doesn't include weekends…
Hi. I have a number of children rows for each parent. The child rows each have a "Status" column which is using the red, yellow, green icons. I'd like the parent row to inherit the worst case summatio…
Hello, I'm new to Smartsheet as of this week and am getting the hang of things, so please bear with me: What I have: * Large datacenter project involving nine teams* technology inventory for each team…
