I want to create a sheet where we can track our tools being used by multiple field foreman. I want a sheet where I can see all of the tools we own and allow each foreman to submit their tool inventories weekly. Can I get some help please?
I might have something that can help and be a starting point.
Can you describe your process in more detail and maybe share the sheet(s)/copies of the sheet(s) or some screenshots? (Delete/replace any confidential/sensitive information before sharing) That would make it easier to help. (share too, [email protected])
I hope that helps!
Have a fantastic week!
Workflow Consultant / CEO @ WORK BOLD
✅Did my post help answer your question or solve your problem? Please help the Community by marking it as the accepted answer/helpful. It will make it easier for others to find a solution or help to answer!
SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E:[email protected] | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
I want to have a "master" sheet where our equipment mgr can see all of our equipment and where it's being used. Our guys are required to submit paper reports now which is very time consuming. Below is draft of what I'm working on.
How do the equipment manager know who has what? Is there a process to request a tool or something similar or is that handled thru the paper report today?
The guys pick up tools from the tool crib and are required to submit an inventory but they don't always turn one in and it's not always accurate.
This report is for lift equipment (separate from small tools) but could be used the same.
The solution I built a while back for another client was for stock and order management and different stages.
I'll need to go through it and see how it could be updated to work. I'll get back to you!
Can you maybe share the sheet(s)/copies of the sheet(s)? (Delete/replace any confidential/sensitive information before sharing) That would make it easier to help. (share too, [email protected])
Create and edit formulas in Smartsheet
Formula combinations for cross sheet references
Smartsheet functions list
OK, this might not at all be possible but I am hopeful and am not giving up until I find out it can't be done... Hello Smartsheet Community!! I've been playing around with creating a Report, specifically a Row Report in that case. It works fabulous and YouTube videos are a great help! This "issue", though, I am unable to…
I need to calculate the number of Network Days based on a Leave Status but if a half day has been checked, it needs to just put 0.5. The formula I am currently using is: =IF(AND([Half Day]@row = 1) [Leave Type]@row = "TOIL", "0.5", NETWORKDAYS([Start Date]@row, [End Date]@row)) But I'm getting a #Unparsable error. What am…
Hi, hoping someone will be able to help with an issue I am having with an IF formula. I am attempting to build an IF formula from check boxes, however it isn't as simple as multiple IF statements returning their own responses. What I am trying to achieve is a status update column, based off of the checkboxes. And therefore…
©2024. All Rights Reserved Smartsheet Inc.