-
Copy Column Properties
Hi, I am creating a new sheet that needs to have 20+columns that are all a dropdown column type, with the same dropdown responses. Is there a copy function for setting up the columns? Thanks, Lisa
-
COUNTIF where cell contains checkmark EXAMPLE
Need a 'countif' example, where cell contains a checkmark?
-
Sumifs with Date Range
Hi there! I'm using Smartsheet to keep track of timelines and allocated ressources called FTEs across multiple projects. I'm trying to figure otut a way using the SUMIFS formula to sum up the usage of FTEs across all projects per month. Currently, I'm using =SUMIFS(FTE:FTE; Projekt:Projekt; "Project A"; Start:Start;…
-
Formulas For Metrics
Good afternoon, Looking for some help on setting up formulas to capture the following metrics per attached. Any help would be greatly appreciated. Thank you !
-
Formula Sumif Range w. Web Form
I have a sheet where I am using a Webform to gather data. Issue is the Sumif formula I have at the top of my sheet will not include the added line entries of the webform entries. =SUMIF(Task2:Task4, Task5, Hours2:Hours4) New Webform entry is line 5, Formula will not automatically capture that added line. Please help.…
-
Love "PRORATE"
The PRORATE function does not exist in Excel (to my knowledge, reinventing it was cumbersome). We use it to spread budget accross time. Indeed, with the right columns and rows, Yearly (can be quarterly, monthly or whatever) budgets adjust as the dates change. Then dedicated boxes consolidate to overview at a glimpse.…
-
Issue with Nested IF Formula
I am having trouble getting my nested if formula to work. I have the following formula: =IF([DCO Status]@row = "Implemented", "Blue", IF(AND([Days Open]@row > 46, [Days Open]@row < 100), "Yellow", IF([Days Open]@row >= 100, "Red", IF([Days Open]@row <= 45, "Green", "")))) It is working for all the cells except the blank…
-
Count How Many between Percentages
Hello, I have a list of documents that are being reviewed. People have to indicate what percentage they have completed. So if someone could be 20% done, someone else could be 30%, then another is 50%, etc. I want to be able to count how many are 0% done, 1 - 30%, 31 - 50%, 51 - 75%, 76 - 99%, and 100%. Is there a way to do…
-
Add row data to a separate sheet ONLY if a box is checked
Ok. After 1.5 hours of trying to figure this out myself, I am reaching out to the experts. I have multiple Smartsheet Forms feeding into one Master Data Sheet. Each row of incoming data is then assessed for approval based on certain cell criteria, and if approved I check a box in the "Approval" column (image belwo). Based…
-
Calculate Points of Symbols?
I have three symbol fields Priority (uses Priority High, Low), Impact (uses Measure One, Two, Three, Four, Five), and Size (uses Measure One, Two, Three, Four, Five) I would like to roll up points in a column for this. Impact and Size would convert to integers, High Priority would add +5, Low Priority -2. Can I do this all…