-
Idea on connecting two Smartsheets?
I have two sheet that i want to reference and update each other. They both follow similar formatting, with one being more of a log/reference for the other. I would like one list to dynamically update the other. How would i do this? Items list - I have a items list that will show an overview of purchase orders to be done…
-
Reference a date based on Percentage complete
In Sheet One, there are 25 products assigned to 4 Product Types. Each Product has an expected delivery and an actual delivery date. In Sheet Two, we want to add the dates associated with the percentage complete. The existing formulas provide the percentages and totals but how can I add the dates for the milestones. For…
-
Affect multiple columns with one conditional formatting rule?
I have four columns, A, B, C, and D. If the entry in column A is "NO", the I want columns B, C, and D (within the same row) to be blacked out. The only way I can see being able to do this is to put a rule in for each column. Is it (would it) be possible to check multiple columns in the selection field when creating the…
-
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…
-
Borders visibility
I am trying to figure out how to control the borders in SS? They dont print well and the grind I am using needs to be seen ?
-
How to loop through workflow
I'm having a problem creating an approval flow. When the approver denies the flow, it automatically sends an email to the one who requested the approval asking him to clear the wrong field. I need that after the field is arranged the system understands that it should again send an email for approval. I do not want to…
-
Flag by Last Modified Date Formula
Hi, I have a sheet for an event we are running and I want to flag any row that has been modified in the last 72 hours (3 days). Right now I have a flag column and a hidden modified date column. Any help with the formula please? Thank you! Jared
-
Conditional Formatting For Date Cell
Hi, I want to apply conditional formatting to a date cell if the date in that cell is earlier or later than a date in another cell. Can someone tell me if this is possible and if so how to do it? Thanks. -Marcia
-
Limiting tasks (by name) to specific days of the week
Hi, I'm looking for a way to control specific tasks being allowed to start on only certain days of the week. For instance, a task name containing "A" is not allowed to occur on Mon or Fri, only possible to start/finish on Tue, Wed, or Thu. Keep in mind, A is a precedent for B, which is a precedent for C. But B and C are…