-
Is there a way to timestamp using a formula?
Apologies if this has been asked previously, I am wondering if there is a formula (or any other method) that can be used that can add a timestamp into a cell for when the workflow was triggered. For example, I have a workflow that sends an email to person 1 and i would like the date and time in a cell that this was sent to…
-
INDEX MATCH on multiple value cell
Hi, I have a column that can be filled from multiple items from dropdown list. On a second column, i'd like to return the matching items to those inserted in a first column. To achieve this, i have a second sheet with each individual item and it's match. Unfortunately when I try the index match formula, it only work when…
-
Formula with Symbols
Hi Smartsheet friends, I would like to use the red/yellow/green symbols, and need some assistance with the formula I have a series of checkbox columns; each column represents a task. When all are checked (true) = green When some are checked = yellow When none are checked = red Thank you! Donna
-
Formula to Update a % Complete on a Row
I have a project schedule with the % Complete, start and end dates. I have a checklist that is another Smartsheet used by another group. I would like to right a formula that will mark a task at 100% complete when the other checklist is complete by another group. It looks like that the % Complete column will not allow a…
-
Help with COUNTIF(S) formula to check for duplicates that meet multiple status criteria, and columns
Hi, I'm still new with Smartsheet and even newer with figuring out the syntax of formulas, and was wondering if someone can help me with a request Currently I have a COUNTIF formula to check a box if there is a duplicate number in the ID Number Column: =IF(COUNTIF([ID Number]:{ID Number], [ID Number@row)>1,1,0) How do I…
-
IF AND ISBLANK formula
I need my formula to read: IF the Comments Log Received is BLANK, AND the Approval Status = "All Comments Resolved" THEN calculate NETDAYS between Date Submitted and All Comments Resolved This is what I have come up with. However it fails. =IF(AND(ISBLANK([Comments Log Received]@row), ([Approval / Status]@row = "All…
-
How to make the date stay the exact date
Hello if something is typed in after 5:00pm, my date goes to the next day. How do i change this ?
-
COUNTA alternative in Smartsheet
Hello, I'm trying to recreate/transfer a salary/reward solution in Excel over to Smartsheet and two of the columns have a rather complicated formula, which has a function I don't believe is available in Smartsheet (COUNTA). When I've tried to replicate it I get an error message (UNPARSEABLE) The formulas are:…
-
Calculating Days
Hello How do i get this formula to Calculating the numbers of Days when i select the date columns. e.g I want to select the dates and then it calculates the number of days from the two date ranges selected.
-
Data doesn't match the data from Excel when replicating formulas
Hello, I'm trying to recreate/transfer a salary/reward solution in Excel over to Smartsheet and I've been able to recreate a good portion of the columns that have complex formulas, but there seems to be a number of discrepencies with some of the data where it is out by a few thousand pounds or a couple of percentage…
