-
QR Coding Tied to Forms
Hello, I'm looking to develop a process for maintaining our mechanical equipment. Ideally a Technician could scan a QR code that would link them to a list of form links. (Each piece of equipment requires 3-5 types of maintenance, requiring 3-5 separate forms) When Creating form links, can they be renamed? Thanks
-
VLOOKUP or INDEX
Dear all, I'm trying to use smartsheet as a Resource Management tool, unfortunatelly we haven't get 10,000ft yet. so what I'm doing is to assign the resources that we need in each project: Project Manager and Allocation % Business Analyst and Allocation % Tech Leader and Allocation % A person can be in different roles…
-
Calculation Sheet for multiple sheets
Hi Guys I have a calculation sheet that is currently bringing in data from 3 external sheets in order to be able to create reports and graphs for dashboards etc My problem is that I am conscious I will reach my cell link limit, along with the fact that 3 or 4 more sheets will soon have to be included in calculations,…
-
Reporting a date range from multiple sheets
Hi! I have multiple projects (housed in individual sheets) that have varied dates for the same deliverables. At a leader level, I would like to display the range of those dates for key deliverables. I am doing this across a large number of sheets (10-50), so ideally would find a solution within the reporting function…
-
Calculate percentage complete on a project based on time elapsed
I need help to finish a schedule for projects based on time elapsed. The current formula that I am trying to use has a Datedif formula but I don't think Smartsheet supports that. Any ideas or assistance would be helpful? =DATEDIF([Projected Start Date]@row, [Projected Finish Date]@row,[Actual Finish…
-
Add Duration to date/time
For a software release plan, I need to show the duration of a task but unable to translate my Excel formula to Smartsheet. Any thoughts? These are the fields I am using -
-
How to Round up date from delta for dates
I have a spreadsheet where I've gotten the Delta (time between end date of task 1 and beginning of task 2). it comes out as an integer instead of a whole number to reflect days. How can I use the ROUND function to reflect whole integers? An alternative: is there a setting within the Smartsheet that would allow for whole…
-
Restore Duration Column
I have a project plan without a duration column (it was previously deleted). Is there a way to restore this so it functions as originally delivered using the start and end date columns?
-
Auto generating due dates for project management
Hello Smartsheet Community! I am attempting to automate our project management for product launches and I need some help figuring out how to set up automated dates in smartsheet. I'd like to 'plug in' a new date into a cell and have the rest of my action plan dates to automatically update based on the number of days it…
-
Formula for health status of overall project
I was using the below formula to provide the health status of the overall project, but its not working. The result (green, yellow or red) is supposed to come back with the majority of the tasks that are in that color. In doing my test, most of my tasks were in red status, but the result for the overall project came back…