Karen_Gardner - profile

Karen_Gardner · Nov 25, 2021

I have a date formula to work out the number of days between 2 dates, if either or both of the dates are blank, it returns NaN, how can I amend the formula to only perform the calculation if both fields are populated? (Long overdue a lay-in and my br...

Karen_Gardner · Nov 10, 2021

Within a base, I have 2 tables that I would like to merge into one, is this possible, or do I have to re-create the 65 records from the smaller table into the larger table that I want them to merge with? (Not sure if it makes a difference, but I am c...

Karen_Gardner · Nov 25, 2021

Perfect, thank you. Worked

Karen_Gardner · Nov 25, 2021

Dimitris_Goudis: IF(AND(LEN({Finished})!=0,LEN({Started})!=0)),DATETIME_DIFF({Finished},{Started},“days”),0) Still getting the same error message

Karen_Gardner · Nov 25, 2021

Getting this error message when copying / pasting the formula.

Karen_Gardner · Nov 11, 2021

Thanks, I will take a look at the steps you mention. I am using the attachments field type and want to take with it the images that are attached when moving it, but there are too many options to know which ones to take across. (When I was initially c...

Karen_Gardner · Nov 11, 2021

Thank you. I have managed to set up an automation to create the record on the new sheet when it enters a view on the source :slightly_smiling_face: As part of the automation I would like to take over the thumbnail image but there are so many opt...

User Statistics

User Activity

Date calculation formula that ignores blanks

Merge 2 tables into 1 on the same base

Re: Date calculation formula that ignores blanks

Re: Date calculation formula that ignores blanks

Re: Date calculation formula that ignores blanks

Re: Merge 2 tables into 1 on the same base

Re: Merge 2 tables into 1 on the same base