-
Sum of Totals by area and Date
I am trying to set up a formula that does the following: If in Work Log A, the Plant is X and the date range is between 10-1-2020 and now, what is the total cost of this time range for this sheet? I also want to break down by monthly range: If in Work Log A the plant is X and the date range is between 1-1-2021 and…
-
Formula help to return differnt conditions
Hi I am after help in developing a formula to look for certain conditions. I require the highlighted cell in blue perimeter to record certain condition if a condition is true from the 5 cells below. If all cells return Completed then return "Completed" If all cells return Not Started, then Return "Not Started" If all cells…
-
Stacked Bar Chart
I am attempting to create a bar chart widget that summaries hours by department on a given project, but I can't seem to figure out how to get it to display the information I need it to. I have the data set up in a sheet as follows: I would like the graph to show each department's hours as a portion/percentage of the total…
-
Removing rows based on a value
I've created an onboarding training template for new hires at my company using the following (https://app.smartsheet.com/b/publish?EQBCT=2a335ca126274786adde88923187b3ca). I've removed some of the original reporting features and added our own. I need to create a version of this that can automatically remove, and re-number…
-
Workflow Question - Decline with An Attachment
Wondering if anybody encountered the same situation here. I have a very simple mechanical drawing approval workflow that works fine if the approver only click on "Approve" or "Decline" button. The approval column will change to Submitted when drawing submitted (trigger by attachment), and changed to Approved or…
-
Using Index/Match with Two Values in Another Sheet
In Sheet 1, I like the prices for services for different vendors: Vendor 1 | Category 1 Service | $10 Vendor 1 | Category 2 Service | $20 Vendor 1 | Category 3 Service | $50 Vendor 2 | Category 1 Service | $70 Vendor 2 | Category 2 Service | $90 Vendor 3 | Category 1 Service | $30 Vendor 3 | Category 2 Service | $60 In…
-
Version Control of Project Plans/Sheets?
Hello, I am wondering if there is a way in Smartsheet to version control the sheets. Basically, we are using each sheet as an individual project plan. However, as projects progress, the plan will (usually) slip and/or have to be updated, so we need to amend it. Since there seems to be no way in Smartsheet to baseline the…
-
Move Rows Doesn't Work When Cell is Linked?
I am trying to setup a process using Smartsheet and the move row function doesn't seem to work. My process includes 2 sheets: 1. Sheet A 2. Sheet B When I change a specific cell in Sheet A, there is an automation to copy the row to Sheet B, which works perfect. Then, I have a DataMesh setup where the Source Sheet is Sheet…
-
Creating Due Dates (Monthly & Quarterly)
Greetings I have been asked by a colleague to build a smartsheet that sets out a list of tasks to be completed and the due date of each task (to be used primarily in calendar view by the colleague to plan her time). Her due date for a task is either made with reference to: (i) a business day in a particular month (i.e.…
-
Formula in Date Column
Hello, I am trying to get a date value from another sheet in a date column using Index(Collect(.......),1) function. However, every time I add a formula in date column it converts to text by adding a ' sign. For Example: Sheet1 has following columns: Location Project Start Date End Date ... .. .. .. I want to move Start…