-
Joining Formatted Cells
Hello All, First time caller...Is it possible to join cells where text in those joined cells have different colors and have the joined cell retain all the various text colors? I've tried =Cell1 + Cell2... and =Join(Range) and both return combined text in default black text. Thanks in advance for your feedback. DT
-
Weekly Tracking for a Dashboard
I have a grid where I am trying to lookup from a grid that people can log issues on. The first lookup is the date range, we want to count all issues within that date range. Then we only want to count by the "Field". On the log it is the column titled Field it is a dropdown of those fields listed on the Weekly trend grid as…
-
Operators documentation
Where can I find documentation for which operators Smartsheet supports in formulas? Note: I am looking for documentation of operands ("+", "&", "<", etc.) not functions (SUM, INT, MAX, etc.). For example, here is the page that documents which operands are supported by Excel:…
-
Countif after certain date
Hi! I'm trying to create a formula that will count the number of rows that have a "Delivery Date" after 1/1/2019. Any row with a date prior to that should not be counted. I also do not want blank rows counted. In the screen capture attached, you'll see all but one populated row should be counted. Any suggestions on a…
-
Formula with COUNTIF and Checkbox
I have this working formula: ="Unit 2G is " + ROUND((COUNTIF([Unit Name]:[Unit Name], "2G") / 14) * 100) + "% Completed" 2G could also be 3G, 4H, and 2H. (Dropdown selection list) I have a checkbox column named: "Task Completed?" How would I use the working formula to not do the calculation until the checkbox is "Checked"…
-
Summarizing a Customer Satisfaction Survey that is ongoing with monthly reports
I have created a Customer Satisfaction Survey with 12 questions that use a 5 point Likert scale. (Strongly Agree / Agree / Neutral / Disagree / Strongly Disagree). I have tested the web page and it all populates the SmartSheet fine. Additionally, the first 5 questions are about the sales person, the second 5 are about the…
-
Unique numbers in a column
I have a sheet that we add rows to everyday. One peice of data that is added with every new row is a case number (unique identifier to show us who we are working on). How can I get a total of unique case numbers? I simply want a count of all case numbers no duplicates. So if case 12345 is on my sheet 5 times I only wanted…
-
effort and allocation-based timelines?
We have a small team, with each member having very a specific area of expertise. As such, our timelines are defined by prioritization of tasks, dependencies, effort, and resource allocation. I want to enter my tasks, set their dependencies, effort in hours, priorities, plug in the resources and set their allocation, and…
-
Formula for calculating installs for a given quarter. Q1, Q2, etc..
i have this formula for calculating installs YTD for a given property. =SUMIFS({Mira Santi Install QTY}, {Mira Santi Install Date}, IFERROR(YEAR(@cell), 0) = YEAR(TODAY())) Not sure how to take this formula to use it to calculate installs for a given quarter. Do i just put the date range for the quarter? i.e Jan 1,…
-
INDEX(MATCH) returns #INVALID COLUMN VALUE
I have two sheets with a common "Name" column between them. I would like for a checkbox in the second sheet to reflect in the first sheet, factoring in that not all of the names will be used in the second sheet. I would normally use INDEX(MATCH) for this purpose. MATCH() is able to return the row number for the Name where…