-
How to track changes via a report for a single cell in a schedule?
Hello, I have a large construction schedule sheet that I will require updates to "Start" and "Finish" dates. To better coordinate with our project controller, I would like to create a report that shows modified dates within the past week. I currently have a report (see attached picture), that pulls the modified column…
-
Task Dependency
Hi Team , As part of Program of Work sheet for a project , i have created a task which is a collection is set of sub tasks that can be completed if only the subtasks has been completed .However ,i am facing this issue where in my end task completion date gets auto filled as even if the only one of the sub task activity is…
-
How to display results from original smartsheet in another smartsheet to create a dashboard
Hello! I am creating an executive summary dashboard for people external to our company. I have a data source smartsheet (primary) that has a lot more detail that I do not want to give them access to. I would like to create a smartsheet that references specific information from the primary smartsheet, but shows the details,…
-
Using custom value for auto-number in primary field.
I read an old post that said use =[Row ID]1 to copy an automated sequence number in to the field specified. I want more that than just 1,2,3. I would prefer V00001, V00002 etc.. to increment for each new row. Is that possible?
-
Is there a way to restrict a row height?
I now in Excel there are functions to lock certain items and I can use the REPT function to have a minimum visible. However, for fields that require many updates and can take up an entire screen, is there a formula to restrict visible height other than unchecking the "wrap" option?
-
Tabulating Sheet Summary Data
Is it possible to automatically capture the results of a sheet summary on recurring basis and save them to another sheet? Almost like a daily cron job. I have metrics that feed a dashboard from a open issues list, but want to track trends over time based on those metrics. Currently I only have a snapshot of the live status…
-
Count if Specific Text within a Date Range
I'm trying to create a formula to count a specific text within a column only when it's during a specific date range. I can't figure out where my error is. =COUNTIFS([Branch Selected]:[Branch Selected], "East Branch", [Date]:[Date], >= [2020-08-01], [Date]:[Date], <=[2020-08-31])
-
Trouble with VLOOKUP - pulling from first row, not column
I'm using the VLOOKUP for the first time to pull webinar times in from another sheet for webinar registrations automatically so we don't have to add those manually before a workflow sends meetings links out to registrants. I'd also like to use it for webinar dates if I can get it to work. My issue is that even though I've…
-
Dynamic numbering
Hi, I wanted to know if its possible to have the entry number as the Function + RAID item(R,A,I,D) + number. What I am looking for is for the R,A,I,D items to be named as per the functions- i.e. if its the 'first' R in Funciton1 , the result should be - Function 1. R.1 and if its the 'third' A in function 4, the result…
-
SUM all payments made in the last year
Hi, I'm trying to add up all the payments in a column that were made in the last 365 days from the current date. The date the payment was made is in a second column, formatted as a date column. I have written this formula: =SUMIF([Payment 1 Paid Date]:[Payment 1 Paid Date], TODAY(@cell) >= TODAY(-365), [Payment 1]:[Payment…