John Littler
John Littler
Reactions
Discussions
- I have notice that the Workapps side panel opens each time I open a new sheet, report or workspace. I prefer to have the real estate on my screen while working, anyone been able to disable this side p…
- Hopefully a simple one here. Trying to calculate number of instances / records per day from a date column? Sumif ? Today()?
- If today is Jan. 28th and I have a launch date of a project of say Oct. 1st, what formula would I use to countdown the days to Oct. 1 for a dashboard widget? So 246 days, then 245 tomorrow and so on.
- Hello community...I am looking to complete a nested IF OR statement and am missing something. I want to return red if either values are below 0, Yellow if both are between 0 & 8 or $0 & $250,000, gree…
- Hi...I'm looking to close a simple IF OR statement and it seems I'm missing something. 2 values where if 1 or the other is less than 0 return "Red" if false "Green" and returning Green is just getting…
- I have 2 pieces of criteria that needs to be met for and a formula to return a date. 1) Lane must equal 5 2) Dollar value greater than $100,000 3) Add 90 days to my date field Populate a new column wi…
- Hello, I am looking to count the number of months remaining in a calendar year without having to change my formula monthly, simply put if the date is 9/15/23 I'd like the output to be "4", if 12/20/23…
- Hi...I'm looking for anyone with experience that has been able to load resource management automatically from their project plan? I seem to be at the point where I need to manually add the tasks from …
- Good day...I am wondering if there is a formula that can bring back results based on time for example today()-created row brings back days...can I bring back hours or minutes?
- Hi...I need help with a formula, I need to sum a value by lane based on a monthly date. I feel I have the date portion correct but not getting the sum part? I need the front end of the formula... AND(…
