-
Edit cells with column formula
Is there a way to edit the cells where a column formula is used? I am trying to link information from 1 database to another via a INDEX MATCH formula, so we don't have to re-write info 2 times. However, the databases does not contain the same projects (we link info based on project number). See below - Project name is…
-
SUMIF and CONTAIN referencing another sheet
Hi Guys, Have got lost in this one, and I think we might be close to cracking it. I am trying to Sum the values from one column referencing a name from separate column, a little like a sales sheet. The complexity is that I am trying to reference another sheet and I keep getting #Unpareseable =SUMIFS({1.Groups WIP Range 1},…
-
Excel exports: error messages
Hi all, Our team is experiencing issues when trying to export a Project Data Sheet to Excel. When I export the Data Sheet I get the following error message in Excel: 'We found a problem with some content in 'Project Schedule.xlsx'. Do you want us to try to recover as much as we can? If you trust the source of this…
-
How to clear a deleted sheet that show in Workload Schedule
Hi, I'm trying on a new Workload Tracking on Resource Management feature. I've created a testing sheet with enabled "Workload Tracking" feature then deleted that sheet. But when I open a "Workload Tracking" feature, it still displayed deleted sheet and I've already delete forever that sheet. How can i get rid of them ? (…
-
How to calculate the difference between two values and display the result with a + or - sign
Hi community! How can I calculate the difference between two values and display the result with a positive or negative sign depending on whether the difference is upward or downward? For example, if I have two values: 5 and -2. I need the following result: -7. And if I have: -5 and -2. I need the following result: 3. Thank…
-
SUMIF(S), AND, IF, Checkbox formula functions
Hi brainstrust, I am trying to build a resource conflict formula(s) that deliver the end results of: If a project row has overlapping dates AND has the same resource type(s) selected (different columns with check boxes) as the date-conflict project rows, return a "conflict" result. AND If a project has a resource type(s)…
-
return the value if the criteria meet 45 days and the name of the client is not empty.
This discussion was created from comments split from: Count If and Not blank.
-
Automation Workflow - External Users
Hi, I just found out today that even though I have set my Automation settings as Unrestricted, so external users with different email addresses will get notifications - in my case, Update Requests - I still have to add these domains in the Domains Safe Sharing list. Lucky that I am also an admin to my organization…
-
Form Issue - The information you entered is incomplete or invalid.
I have a form that worked approximately 3 weeks ago (and for months before that) but now everyone who enters information on the form gets the "The information you entered is incomplete or invalid." message. Thankfully, the form is just being tested so it hasn't impacted operations but it has stopped us from rolling it out.…
-
Calendar subscription not showing on all user iPhone/Mobile Outlook app
Hello supersmart community! I have a calendar view that has a link we can subscribe to in our Outlook calendars. Works great. The issue is that some users cannot add it to their Outlook app on their smartphone. It should show up like the image below, but it's not there or in any other calendar lists. They have subscribed…