-
Formula to add 30 days to create date and insert into a cell is if value is blank
Good morning. I have a sheet where we are placing dates for follow-up on projects that go on hold. In the form we ask for a planned restart date but sometimes this is unknown. When that date is unknown we want to trigger a reminder for follow-up 30 days after the date the row is created. I have a created date field and I…
-
Create a formula that returns the current project phase in the project summary metadata sheet.
The phases in my project plan are Level 1. The formula should return the text value of the phase (task name) that has the least % started, NOT including phases at 0% or at 99% and higher. =INDEX({Task Name}, MATCH(MAX(COLLECT({Level}, {Level}, AND(@cell, 1), {Level},1) AND(MATCH(MAX(COLLECT({Project 10 - % Complete},…
-
SUMIFS Formula Help
Hi there, Super stuck on how to get the below working, any help/advice about where I am going wrong would be greatly appreciated. Smartsheet 1 - Data Sheet, where: Range 1 = Dropdown list column Range 2 = £ value Range 7 = Contact Column Smartsheet 2 - Summary Sheet, where I am building formula (hence the References above)…
-
Track Project Changes and showcase the ripple effect
Hello SS Community :) I was wondering if anyone knows of a way to track project changes and more so how to showcase the ripple effect of that change. I guess sort of a what if analysis, if I pushed the date back on this task how would that affect the overall project or what part of the project would be affected? Would this…
-
Counting # of Overdue
Hi, I am trying to count the number of Overdue rows using two deadline columns (Due Date 1, Due Date 2) and a Status column, so using both of these criteria: Determine if the deadline has passed from the earlier of the two deadlines Eliminate from the count any past due rows also marked as Completed in the Status column…
-
Is it possible to display a graph from an excel file hosted on Sharepoint on a Smartsheet Dashboard?
I understand it would be possible to upload the excel file into Smartsheet and display it that way. I'm looking to see if I can link to the excel file itself and have the excel graph displayed automatically in real-time in a Smartsheet dashboard? Thank you, Jeffrey
-
Index Match (No Match)
Im pulling in information from another sheet to the sheet in the image below and I cannot figure out how to only make the date show up when there is a match. I do not want "No Match" to appear. =INDEX({picked up}, MATCH([Ticket #]@row, {ticket number}, 0))
-
Possible to use cell linking for formulas?
I have multiple sheets that are set up in the exact same way, used by various team members. Each sheet has several formulas. If there is an update to the formula, I have to go into each sheet and adjust it. Is it possible to have a reference sheet that houses all the formulas and use some kind of link to reference the cell…
-
Calculate time
Hi Everyone, years ago, I was told that smartsheet does not calculate time. Has the ability to calculate time been added? It would be nice to move this task over to smartsheet from Excel. I am looking to get the results in the blue column.
-
Approval Workflow Not Triggering
I'm trying to set up an approval workflow when a submitter doesn't give a 90-day notice for a meeting request on Smartsheet. Every way I set it up, it won't trigger!! I require a 90-day advance notice to approve a meeting. When a request comes in on Smartsheet, I need to set up an approval request automation for this as it…
