This website uses Cookies. Click Accept to agree to our website's cookie use as described in our Privacy Policy. Click Preferences to customize your cookie settings.
We interview students and each student goes through 2 interviews by 2 different interviewers. Each interviewer has their own column with their interview time. See an example. If we take the interviewer Ross as an example, how can I get to the point w...
I have a column of case numbers. The numbers can be made up of a number only, for example, 832, or a number with a slash and a number after it, for example, 832/1.I need to create a function that searches for all the numbers that do not have a slash ...
Unfortunately, this solution does not help me I found a partial solution how to show only Ross: https://prnt.sc/4wIQ2VeOzdAbI opened a new column called "Interviewer" and inserted the following formula into it:IF(OR({Interviewer 1} = "Ross",{Intervi...
I think I found a solution. In the formula that I wrote, instead of writing the function NOW () I wrote the function DATE_MODIFYׁ() and it gave me the date automatically. I entered my Base today and saw that the date remained yesterday's date. Hope I...
I need the date to be created only when I change the curtain field with a certain value.For example- IF(Status="YES",TODAY()) I need something instead of TODAY function...
