-
Multiplying cells from different sheets
Sheet 1: Work Scheduled (number of work units scheduled in a given month) Sheet 2: Budgeted Cost of Work Scheduled (to determine the total cost of the work scheduled in a given month) I would like to multiply a cell from Sheet 2 with the corresponding cell from Sheet 1 and then be able to copy/paste the formula so that it…
-
How to bid Materials - Construction question needing solution:
Hi Smartsheet, I have the following problem. I am a contractor that has to go around a home and take a materials count on a list of tasks say a door install, window install, etc. Anyways, I am trying to figure out the quickest and best solution to take a materials count for my given tasks and then fill in the info I'll…
-
SUMIFS formula question
I’m working on a SUMIFS formula to add/sum numbers in 2 or more separate cells based on a checkbox input in 2 or more other cells. I’m able to do so only if the number columns and the checkbox columns are next to another. Is there a way to do so even when the columns are NOT next to the other? Here are snapshots: The…
-
Smartsheet and Trello - Custom Fields import to Smartsheet
Hi Community, I am in the process of creating a new Team workflow and I would really appreciate to discover how to easily import Trello Custom Fields into Smartsheet. I am aware of the Trello import procedure https://help.smartsheet.com/articles/504553-import-files-to-create-new-sheets, which is working correctly, however,…
-
Indent from a form
Is there a way to have a row come in automatically at the same indent level as the row above it? My top row is a parent row with calculations based on all of its children. The children rows are all web form generated and they do not come in indented so I have to manually indent each row as it hits the sheet.
-
Can I add something to color code for blank cells?
Hello, I am using the following formula to represent health color for individual rows: =IF([Start Date]40 > TODAY(), "Blue", IF(AND([% Complete]40 < 1, [End Date]40 < TODAY()), "Red", IF(COUNTIFS(CHILDREN(), "Red") > 0, "Yellow", "Green"))) This formula works well for what I need except that I use a template project sheet…
-
Calculating average difference in dates between two columns
Hi I am trying to find the average time to complete a task without adding additional columns in my sheet. I would like to set it up in the sheet summary for easy reporting. In excel I would use the following formula. If a cell is blank the row will not be calculated as part of the average.…
-
Add RTF (rich text formatting) to Comments
When creating a project many times the comments are as much instructions, as comments. Just like this modal when creating community comments, add the ability to apply Rich Text Formatting; Bold,underline,bullets, and numbered lists. RTF functionality would be limited to manually entered items, not pasted items. The…
-
Metric sheet - can you create a chart off two different sheets on metric sheet
I have active project sheet and a separate pipeline project sheet. I have a metrics sheet that includes data on the active sheet. I see that I can create metrics from pipeline sheet in different columns. But what I want to do is create a chart based off the metrics from both. So Ideally I would like project by status and…
-
Getting Started Tutorial for Customers
We have built out a 'project portal' of sorts made of up several sheets, reports, and dashboards. I'm looking for anyone who has done the same and/or built a 'getting started guide' for customers to understand how the project will be managed utilizing all these components (information, status, collaborations, etc.). Anyone…
