-
Running total cost
I am trying to utilize a sheet for cost tracking. I have a column where the dollar amounts are being put in, how can I just have the value of the column to keep a running total?
-
How to display numbers in billion in a cell and that is linked from another cell with currency
This is my current formula for million but I need in billion. Please help thanks ="EGP " + LEFT([Total 2023]57, IF(MOD(LEN([Total 2023]57), 3) = 0, 3, MOD(LEN([Total 2023]57), 3))) + IF(LEN([Total 2023]57) > 3, "," + MID([Total 2023]57, IF(MOD(LEN([Total 2023]57), 3) = 0, 3, MOD(LEN([Total 2023]57), 3)) + 1, 3)) +…
-
Due in Days and conditional formatting question
I have this formula (below) to calculate my "Due in Days" column, and a conditional formatting rule that states "If due in days is less than 0" then apply a red font. but I'm wondering if I'm able to have it display no number once the task has been completed, or at least remove the red font once the "Status" column…
-
Set default timezone for Folders
I am managing about a thousand employees spanned across the US. All of these users are in 1 workspace, distributed into folders for each region. The idea is to set folder level default properties for time zone. Many times a user logs in and is defaulted to the incorrect time-zone because the laptop they're using has…