-
How to get the count of unique values from a list of repeated unique values
I have a list of people lets say Jon Sam Rick each on of them is assigned to a colour lets say any combination of colours for something that looks something like this ( see screenshot). How can I count the number individual colours for each person. For example Jon has a combination of 5 red and 5 green so his count should…
-
Cross-sheet predecessor without using cross-sheet reference
In sheet 1 there is a date 1 which is a predecessor (SF type) for last task in sheet 2, so that date 1 is later than any task in sheet 2. When I use a cross-sheet reference to import the date 1 into sheet 2 and then simply use it as a SF predecessor, it does two things that I need to avoid: it erases the critical path for…
-
How do I create a report that sums totals from my sheet?
Hi, I need to create a report that sums up the totals of each quarter on a report. How do I do this? I would normally use a pivot table in Excel for this, but I'm not sure how to recreate that same functionality in Smartsheet.
-
COUNTIFS between dates & criteria.
Greetings Smartsheet Community, I am attempting to cross reference another sheet and Count all the Completed tasks within a certain time frame. So far I am successful counting the dates in the range using the following formula: =COUNTIFS({Range 1}, <=DATE(2018, 4, 31), {Range 1}, >=DATE(2018, 4, 1)) Next I'd like to add…
-
Is there a way to have dynamic cell updates? My previous attempts were unsuccessful.
I have two (or more) sheets, one sheet called “Master Sheet” and another called “Library 01”. I want to create a drop down in Master Sheet with Options “A-H” which populates data from Library 01 and automatically changes based on the option chosen from Master Sheet. Is regular Smartsheet capable of this? I've tried using…
-
Keyboard Shortcut for "Link from cell in Other Sheet" aka "Cell Link"
I have to cell link from other sheet quite often. Right click on mouse, then select "Link from Cell in Other Sheet…" every time gets very old and not great for my wrist. Please add these keyboard shortcut! 🙏 Thank you!
-
Ideas on how to effectively create a new sheet that collects information to update status on another
I am struggling to find other answers on the community for this situation. We are creating a log of all equipment. I am creating a second sheet for when that equipment is removed. When someone submits through a form that equipment is removed, I would like the second sheet to automatically update the status on the original…
-
Can I link a cell to a folder on my hard drive?
-
Merged: Cell Linking And Referencing Sheet Summary Fields From Other Sheet
This discussion has been merged.
-
Linked Cells Not Updating
I am trying to figure out why my linked cells are not updating. When I double click on the current value ("TBD" in this case) it opens the source sheet and shows the updated value ("Bridgeport Village" in this case). Right clicking the current value and selecting "View Cell History" shows no change as well. Any idea why…