-
Flagging rows based on number of occurrences within a range of another date
I have a sheet where I want to count the number of occurrences of the same [PI Name] within a 30-day period [Sx Date]. I only want to count each PI once on any given date. I've given an example below to show how I want the counting done, but the solution can look different from this. Whatever solution I use will have to be…
-
Paste Special > Links to copied cells is greyed out
Hello My option to paste special > links to copied cells is always greyed out, even when trying to paste into the same sheet and column. I've tried different browsers and sheets. Any help gratefully received!
-
Linking end dates to another smartsheet
Hello, I am looking for some suggestions on how best to link an end date. I am creating an integrated schedule with fairly simple sheets. I do not understand why I cannot link an end date. I appreciate any suggestions as I am a newer user.
-
Modified SUCCESSORS() function to report more than just direct successors
WHY IS THIS USEFUL? This updated function would allow us to filter the spreadsheet for only the driving path to a particular row#. This would be similar to a filter for critical path, but enable much more flexibility. Current status: I've successfully generated a "Successors" column, listing direct successors of each row,…
-
I created a date column to generates dates by adding few fields but I am getting an invalidoperation
my formula is returning number of dates, as in adding dates.
-
Stopwatch Style Time Tracker
I believe the community has been looking for a solution for years. I have successfully created a way to have Stopwatch Style Time Tracking – On any sheet, at the parent or child row, by individual, and allowing manual edits! This is without using Resource Management. I used Bridge to handle the automation and two sheets…
-
Stopwatch Style Time Tracker
I believe the community has been looking for a solution for years. I have successfully created a way to have Stopwatch Style Time Tracking – On any sheet, at the parent or child row, by individual, and allowing manual edits! This is without using Resource Management. I used Bridge to handle the automation and two sheets…
-
Carry over info from one sheet to another
Hello all, I have a source sheet that i trigger an form from another sheet (i embedded the form link to the email). My issue now is that i need to get the ReqID (from source) and have it read only in the new form, that will record in the destination sheet. Bottom line i need to find a way to link the ReqID from source and…
-
Cell Links Between Sheets Don't Work Consistently
Hi - I have set data mesh cell links between multiple SmartSheets that I own. The properties of the columns on the different sheets match. In the Data Mesh set up, I've selected: To overwrite content To create cell links To run immediately I have multiple instances where data changes on the source sheet and does not update…
-
Linking another Sheet
Hi All, I am having some challenges which I was hoping someone might be able to help me with… There is an existing Smartsheet that a project team uses to display new product introductions. As this sheet is updated in real time and I am not in that team, I can't add fields that I want to track into that sheet; however, some…