-
Project plan header is not pulling/rolling up from sheet rows
I just realised the top row is not rolling up percentages, dates or durations. Dependencies are enabled, and the entire rest of the sheet is functioning fine (so I don't want to disable dependencies), but nothing is feeding that top row that feeds my reports. I just manually put in the start and end date - which should…
-
Does INDEX(MATCH) work on a WBS column with WBS values generated by a formula?
Hello, I have created a project schedule template for my team, with tasks, subtasks and associated timelines on one sheet. I have a second sheet where I am creating a procurement template to track our project materials. I would like the procurement template to pull the task name and target date from the project schedule by…
-
Formula for Updated By and Updated Date Fields
Hi all, Question about a formula I am trying to get started. I want to make sure this is possible before going much further. I have ONE sheet that has four different reports pulling off of it. Each report has 5 lines that Project Leads can update. We are want to have two fields (in the sheet) that autopopulate the Name of…
-
Background auto-refresh a sheet as frequently as every minute.
This might be my first real contribution to this community, but I think I have had a breakthrough with respect to background auto refreshing a sheet. I've seen the common solution of utilizing a workflow to trigger a daily update of a date column, but the challenge has always been that you are obviously limited in how…
-
Can someone please help me with SUMIF formula?
I am trying to use a formula that will add value in children cells when cells do not include an asterisk in front of the value. Basically, I am creating an invoice tracking spreadsheet and I want to be able to input expected monthly invoices (based on the contract) on the front end, but not have those values added to the…
-
REMOVE IF SLOT IS TAKE
Hello! Can we remove a time slot in the drop down on a specific date if it is taken. Below is an example. For example if someone Booked - Dec. 31, 2023 - 9:00AM - 9:20AM, can we automatically remove that from the drop down list since someone booked it? What are the ways?
-
Integrating non working holidays on another country
Hi fellow Smartsheeters, I encountered this problem after entering American holidays but our operations is affected by other suppliers in other countries like China. I think many of you have been affected by week long holidays like Chinese New Year week. Is there a way entering a certain countries holiday without making it…
-
How do I get my events (recurring) to show up once a week in calendar view without manual input?
Here is the sheet with the two meetings that occur once a week: I want them to populate once a week automatically without manual inputs and to show in calendar view every week:
-
Merged: Version History
This discussion has been merged.
-
Prevent Unintended Changes by Disabling Removal of Logic when renaming dropdown items
I was editing the value fields within the column. One of the dropdown answer choices was “New Request”. I simply just added a new word “New/Continuation Request”. When I added the new word, that’s when I found all of the associated logic removed. I never removed a field so in theory, the associated logic shouldn’t have…