-
Creating Pie Chart with Non-numeric values
Hi, I would like to build a pie chart that reflects some number of red, yellow and/or green status in a bug tracking sheet. Since pie charts seem to require numeric data, I think that I need to craft a formula that will assign value of 1 to all colors (RYG) then count how many there are of each color. This way, when I lookโฆ
-
Is there a way to create a search box?
We are wondering if anyone knows how to build a public facing sheet that has a search box where customers could type in a word or two and then have it return any hits. The data that would be searched could be linked to another sheet and that file would not need to be viewable on the public one. Is this possible?
-
Duration roll up values not displaying accurately
My duration roll ups for child/parents are not working as expected. Can anyone advise of things I could try to resolve why only one parent has a duration total?
-
Conditions / Rule formula set-up
I am working on a sheet, and I am very new to this application, where I am tracking P.O.'s, date ordered, date received, etc... and I have 2 columns (at the far right of my sheet or end) that I would like to If the P.O. Total is < or = to the Invoiced Amount the cell would turn greenย and if it was > than to turn the cellโฆ
-
if - and formulas auto populating checkbox
I've created a column titled "Outstanding Approvals", I would like the column to auto populate the check box when "Approval Status" is empty AND when "Start Date" has already begun. I'm using it so I can pull multiple sheets into a single report - but not all the sheets have the same layout. Any help is great! thanks inโฆ
-
Using SUMIF Formula Help
Hey everyone! I just started using Smartsheet and so far am blown away by everything! At the moment, I'm trying to use the SUMIF formula to calculate a total cost but only if the number being used is below 0. For example, If Column A is a negative number, I need the formula to subtract it from Column B, however, if Columnโฆ
-
Date formula question
Good morning, we have a sheet we are using to track leads. I've been asked to set up an automated update request to send leads that have a certain status out on the first business day of each month. In the automated actions, there is no way to set a recurring update request like there is on the row-level update request. Soโฆ
-
MONTH and COLLECT
Is there a way to use the MONTHย function with COLLECTย to, say, find the highest date in a column that is in the month of October? Basically, to simplify a formula like this: =MAX(COLLECT([Due Date]:[Due Date], [Due Date]:[Due Date], >=DATE(2018, 10, 1), [Due Date]:[Due Date], <=DATE(2018, 10, 31))) to something like this:โฆ
-
Date
Hi! I have a tricky formula I'm trying to calculate, but with no success so far... I have to different sheets that I'm looking on. Sheet1: Planning andย monitoring sheet Sheet2: Work reports The formulaย challenge: Inย Sheet2ย our guys at the field are reporting on differentย predetermined projects. They report which date theyโฆ
-
Sum rows if shared value in another column?
Hi, I'm trying to summarize hours worked on eachย project for each month. My list of projects changes regularly with some coming in and some going out. Data is collected weekly so there will be multiple entries for each project. My thought was to SumIF the project identifier matches. I'm new to Smartsheet and have searchedโฆ