-
Cell link data from helper sheet to a new sheet
Hello, I have an initial sheet (Sheet A) automation then copy's (status triggered) rows to a helper sheet (Sheet B). Cells from helper sheet (Sheet B) are linked to a new sheet (Sheet C). I am now looking to automate this process where each time a row is copied into Sheet B the same linked cells from the new row copy to…
-
I need to Sum a column from a reference sheet and display the number in my primary sheet
I am attempting to build a column formula that generates the sum of hours for a given phase (task). This is an interaction of our Main project grid and the Timesheet grid (it is one of the advanced reports Resource management offers) from Resource Management. Our main project should display the number of hours incurred for…
-
Cell-linking from another sheet in the Predecessor column
Please enable the ability to use the cell-linking from another sheet in the Predecessor column. Importing dates from another sheet in a new row and then using them as a predecessor can disrupt the duration and critical path of the project. Thank you.
-
Linking a field in a form to a source sheet as picklist
I already put in a ticket and got the answer this is currently not possible, but was encouraged to put in a post here to hopefully being integrated one day. In my situation we have a huge list of project names (and constantly growing) that we'd like to be able to pick from in a from related to a SmartSheet. We find that…
-
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!