-
Date Formulas based off Created column calculating from / converting to GMT
Hi all, I've just discovered that date formulas pulling from the Created column will convert the date and time to the equivalent Greenwich Mean Time date and time. For our central time zone office, any submissions that occur at 7:00pm or later will show a formula-driven date of 12:00am GMT, which is a day after the Created…
-
COUNTISF not counting if >< value is = to zero
Hello, I have a formula that works as expected as long as the >< or ='s value is greater than 0 however, when I adjust the formula to count the number of cells with 0.00's nothing is returned. Respectfully, there are eleven cells containing 0.00. What am I missing here? Working formula: =COUNTIFS([Date of Warranty…
-
If Blank Formula
Can someone help 'I am trying to add up a Value Column (2021 Opportunity Log Range 1) with the criteria if the (Estimator) column is NOT blank and the (RANK) column has a "A" in it. My formula above I get the below
-
Formula not working
Hello, I have a late task checkbox that isn't working. The formula is to compare the baseline start and finish duration to the actual start and finish duration, if the actual dates are longer, the checkbox should automatically check. =IF(AND(NOT(ISBLANK(Duration@row)), [Duration (Actual)]@row > Duration@row, ([Finish…
-
merge cells.
Is there any way to merge cells in Smartsheet? this is critical to me and the JOIN formula is not the easiest way to address this like excel. Thanks, Eberto.
-
Using DATES and MISSING dates
I'm trying to calculate how long a request is open, referencing another sheet. for example, I want to get the total number of days from start to finish of a request in one sheet, and then average them in a statistic sheet. I can get the total number using NETWORKDAYS but if there is NO completion date yet, I'm getting…
-
Top Row
Hello, I have a colleague who has a sheet that has trainers listed followed by agents that are in their class. They are not organized in a hierarchy, but I was wondering if there was a way to locate which trainers have all "active" agents for their classes. Each class is a different size, I know putting it in a hierarchy…
-
Blank cells in column to return another column value
If the cell in {WIP%} column is not blank then return the value of {Tippa Total Value} Column. Were have I gone wrong =SUMIFS({Tippa Total Value},{WIP%},ISBLANK(@cell))))
-
Cell link from another sheet based on conditions
Hi all, I hope someone can help as I've been racking my brain trying to work this out! I have multiple sheets that work together of which the data changes each month (it's based on electricity bills with varying monthly kWh (in pence) rates). I essentially want to link a particular cell from one sheet to another sheet,…
-
Dynamic Approver Contact Workflow
I've have a workflow that requires two different approvers depending on the input from a form. I can automate who the approvers should be and capture their emails in the sheet, but can't work out how to get the workflow automation to send the approval email to those specific dynamic individuals. Can someone help me with…