-
Start and End date editing on my Ipad
I’m new to Smartsheet. I’m using an iPad Air to schedule construction projects for my company. In the Gantt view when I attempt to edit Start and End dates, the windows for them appear gray and it will not allow me to edit them. The other editing options windows are white and they allow editing. I am an admin in our…
-
Automatic "Cell linking"
*What would be the best way to create a permanent link between cells. What I want is that if the user knows one of the bits of information, i.e. "WXP" that the other 3 cells get filled in automatically. We basically develop real estate and the project might start out known as the "Nome project" and gets assigned a Project…
-
maintenance sheet work machines
Hello, Does anyone know how to make these cards (type card attached screenshot), connected with SmartSheet that can be connected to another management control worksheet?
-
Resource Allocations based on Capacity
I am trying to figure a way to do resource allocation based on the number of projects a particular sub can handle at one time. We have 20-30 projects next year and trying to award bids based on capacity of the subcontractor. For example, one electrician maybe able to handle 3 projects at a time vs another who can only…
-
Move to Another Sheet
Hi all - can't help but think this is a bug! I have 2 sheets - They are identical as one is just a copy of the other. I am the Owner of both. I had a workflow that moved rows based on a status change from one sheet to the the other that worked great - until it didnt! I have tried EVERYTHING to try to fix this and still get…
-
HELP ON FORMULAS
I am trying to create a formula that will change the production status automatically. My [production status] column is a drop down box with these options "Roof Ordered, Roof Delivered, Roof Building, Roof Complete". My other columns are date columns, so when the column [Roof Delivered on] has a date in it I want it to…
-
#NO MATCH when counting the results of a VLOOKUP
I am trying to count how many items fit 2 criteria, one is the year, the other is the state. The issue is coming in with the state, as I just changed it to a VLOOKUP and my formulas were all working before I did that. The VLOOKUP is working, but there are a few values which return a #NO MATCH and I can't change that due to…
-
Adding an additional requirement to a formula
We have been using this formula to add up the hours spent working specific clients -- been working fine. We have also been asking what category of work they have been completing at these clients but haven't been utilizing the data. =SUMIF({Kinsman - Job#1}, [Scope of Work]@row, {Kinsman - Hours#1}) I now need to add an…
-
Summary Fields: Percentage of Completed Checkboxes
I'm very new to Smartsheet and hoping someone can help me. I have created a checklist, with different categories divided up by parent rows, and the tasks listed as children under the categories. I have a checkbox column and each task (in the children rows) has a checkbox. I have figured out how to calculate the percentage…
-
Can a Viewer Respond to an Update Request?
Can''t find an answer to this. I need people to be able to respond to update requests and enter info there, BUT NOT enter anything at the sheet level. Can a viewer do this? Thank you!!
