-
Combined Multiple IF CONTAINS Functions
Hi, I have the following formula =IF(CONTAINS([Column A]@row, {Sheet A Range 1}), "Sheet A", IF(CONTAINS([Column A]@row, {Sheet B Range 1}), "Sheet B") Now I want to add if both sheets contain [Column A]@row, result: "Sheets A and B", How do I add this last part in addition to my current formula? Any help is appreciated,…
-
Enhance Auto-Populate Feature for Drop-Down Lists
For long drop-down lists, it is nice to be able to start typing a value in a cell and use the auto-populate feature to reduce the options from which to select. Currently, the auto-populate feature only works if the user starts to enter the value exactly as it appears on the list. Instead, please enhance this feature such…
-
How to set up an email reminder 7 days after creation date
Greetings, I'm trying to set up an automation to send an email 7 days after creation date but I'm having problems. I tried using the function =IF([Creation Date]@row) > TODAY(+7), 1, 0) but it isn't working as expected. When I change the date with a test date from a date column, it works fine. Any ideas what I am doing…
-
Any idea on what Understanding and Hand on experience in Tabular user interface means
The phrase is showing up in job descriptions. Thank you
-
Date Calculation not working correctly
In my Operating Calendar sheet, I have a Due column (date). This due date column should be calculating based on a formula that adds the "Days From Pricing Group OR 1st Departure Date" column to the "Pricing Group Date" Column (=[Pricing Group Date]@row + [Days From Pricing Group OR 1st Departure Date]@row). Both the "Days…
-
How to calculate Status Indicator using %Complete and Target Finish Date
I am trying to achieve the following: IF the %Complete equals 0%, then status indicator is Gray. IF the %Complete equals 100%, OR the %Complete is less than 100% and Today is before the Target Finish Date, then the status indicator equals Green. IF the %Complete is less than 100% and Today is within 1 week of the Target…
-
How can i read activity log using c#.net through API...?
I need to restore a specific row which are deleted from the original sheet, and i am using API to achieve this with C#.NET. Our idea is to create new helper sheet using c#, which contains deleted rows in it, That has to get updated by reading data from activity log May i get any suggestions. Thank you in advance.
-
Today Function
I'm using the Today function to track weekly data counts. I'm wondering if there is a way to use the function to work backward from "Today" instead of forward?
-
Milestones showing at start of next day vs. end of day
I noticed a change in the milestone logic today, and I'm wondering if there's a way to revert back to how it was before or if there is something I'm missing. Before today, a milestone (a task with 0 duration) would show that milestone occurs at the END of the day of the predecessor task. But now, it has the milestone task…
-
Project-based timesheet approval + automatically add team members to a project
Issue: For a Project-based timesheet approval flow it is necessary to add the team members to a project. A Project Owner needs to add someone to the project first to be able to see their time submission. Booking someone for a project for the first time, would make this person a team member. However, RM isn't handling this…