-
Return cell value generated by SUM formula as a number
Is there a way to return the numerical value of a cell that contains a formula that is counting the number of checked boxes in its children cells? My current formula in the cell is: ="Complete: " + SUM(COUNTIF(CHILDREN(), 1) + COUNTIF(CHILDREN(Complete96), 1)) in order to count the number of checked boxes in all children…
-
Text indicator when pasting values
I have a 10 digit "Store #". We use the right 5 digits as a "Site ID". I did a "Right" function to grab the 5 right digits. My Index/Match formula returned a #No Match error. So I copied & pasted values to get rid of the formula. Index/Match still did not work. I found a hidden leading apostrophe (like Excel when you want…
-
sumif formula
=SUMIF(Date past due: Date past due,>TODAY(), Amount:Amount) #unparsable The amount is coming from a vlookup from another smartsheet The past due date is a formula with in the same sheet
-
VLOOKUP data type question
I'm using this vlookup formula to pull back a value from a data sheet. Let's say the value of NUMBER81 is 123456 and when I type in the formula on the desire sheet it returns "No match". When I go to the ACCOUNTS sheet and look at the data there is a value equal to 123456 in Range 1. When I put an apostrophe in front of…
-
Special formula help
Hi, I'm hoping smartsheet community can help me with an automatic formula. We have a column called "Priority Deal" this is a symbol selection of the stars, where we rate a specific land opportunity (empty/one/two/three/four/five) I'd like to create a formula when a specific star is selected, the column "Deadline Date" is…
-
Creating less than today check box
I want to create a formula that has a checkbox that will check if the due date column is between today and 7 days. It works but when i format it to the entire column it checks off every because because it considers that if the due date column is blank it's less than today. My formula is: =IF([Proposed Due Date]@row <…
-
IF and VLOOKUP
Hi Can anyone help me with these two formulas I am trying to do: 1. IF a cell with a checkbox is true, then run this VLOOKUP formula, otherwise 0. 2. IF a cell contains this text, run this VLOOKUP formula, or IF the same cell contains this text2, run this VLOOKUP formula, or IF the same cell contains this text3, run this…
-
Reflecting only Parent Rows (multiple) on Dashboard
For a project release, we're leveraging checkboxes to track completion of validation tasks. I have a dashboard built to reflect progress, however am having trouble finding a way to only choose the multiple Parent Rows/Roll Up data, as it's making me include child data or nothing.. (including all the child row stats will be…
-
Is there a way to display elapsed time for a project?
Hey everyone! I have a project which has the obvious "start" and "end" date columns and Smartsheet automatically calculates the actvity duration. Is there a formula or something which will calculate and display "elapsed" time from start based on the current date? Thanks! Steve Stutz
-
Checkbox tick then auto highlight certain columns?
Hi, We have a sheet called project milestones for managing the steps of LIVE manufacturing an installation projects. I'd like when our production manager selects a tick box on a specific row, that 4no columns within the row are automatically highlighted light green. The column "In production/ Approval Docs uploaded" Should…