-
Creating a Purchase order spreadsheet
Wondering what template might be the best way to create and share a purchase order system for our construction projects. I want to add links, pictures, pricing quantities etc. Can anyone help with this
-
If/And statements
Hi All, So, I am trying to set a trigger flag to be checked when a request is within a certain amount of days and not approved or denied. I would like the flag to trigger a reminder email to the approver indicating the request is imminent and they have yet to approve/deny it. I can't seem to get the IF/And function to work…
-
Series of Checkboxes triggers complete
We're using Smartsheets to track our projects through the production process. We have one sheet that is just a list of the items, with 6 check boxes signaling that portion is complete. When all 6 check boxes are marked "checked"/true, I'd like the last column to automatically update as "completed." I've looked around and…
-
How do i - If this is checked , then check this on another sheet?
i have 2 sheets to reference first sheet has a confirmed check box column but on another sheet i want it to check a box as a pilot user if the confirmed was checked... is there a way to do this with a formula?
-
How to track tasks that are behind schedule
I'm looking for options to track my tasks that go beyond my baseline date. I don't want to simply update the baseline date because I won't know how far behind they are. Is the only option to create another column for actual completion date?
-
Changing date within formula
I am looking to find a way to incorporate a changing value to the hours needed per day in order to meet deadlines. In addition i've input task completion % in order to account for the completion rate. My current formula is the following : =IF(ISNUMBER([Man Hours Allowed]3), ([Man Hours Allowed]3 / Duration3) * (1 - [%…
-
Nested If Statement with If/And in it
I'm having trouble adding If/And to a nested IF statement. Hoping someone might be able to spot where I'm going wrong. What I'm trying to do is automate a red, yellow, green, blue column. The last criteria combine criteria in two separate fields. Thank you! =IF([Approval Status]1 = "Denied", "Red", IF([Approval Status]1 =…
-
Adding Month and Days to a Cell
Hello everyone, I have a Completion Date of 1/08/2019 and I need the next cell to be 1/29/2019 (which is ten days before 2/8/2019) and the third cell to be 2/18/2019 (which is ten days after 2/8/2019). I've tried every which way I could think of to get this to work. Any ideas? THANK YOU!
-
SUM or COUNTIF across sheets
I have a Smartsheet for each fiscal year, and will continue to add new sheets for each FY. On a separate sheet, I want to find the sum of values that appears in all of the FY sheets. For example, if I want to sum the total amount an employee makes on my Summary Sheet, referencing data on multiple FY sheets, I know I can…
-
How do Link a Column w/ drop down items between separate forms/sheets?
I'm new to SS. This is my first project. I have an audit process I am building for a customer. There are 5 separate forms needed for the audit process. I originally had all 5 forms feeding the same sheet but with over 100+ columns for each audit, I went crazy scrolling left to right looking for the information I needed and…