We have a report that includes the planned completion date of a project. A colleague is running the report in India and any date/time that is in the afternoon, converts to the next day when she exports the report. We are assuming it is doing an adjustment for time zone. But her profile is set to ...

Yes, at first I thought it was a bug. It seems weird that everything would update. Thanks!

So that did work but here is my new issue. I actually have 4 separate calculated fields similar to this one. That was for results, we also have one for questionnaire, tables, and exploration doc. They are all separate fields but with similar calculation. For example, IF(ISBLANK(Tables Posted Da...

I think that works! Thanks so much. I was totally overcomplicating the formula.

Hi Teale,Thanks for the response. It isn't working quite right. The one thing you mentioned:IF the Results Date field is populated and the Results = Posted or Updated then the Results Posted Date should equal the Results Date field, is not what we are looking for. If the results date is populate...

Background: We have a pull down field to indicate the status of results. (In progress, posted, updated, N/A). The default is in progress. We also had a date field that would show if posted or updated was selected and the user would enter the date. We really wanted the date to autopopulate the da...

One other quesiton on this. It works great on the details tab but I noticed in summary view, it just says SUM: but no amount. Is there something I need to add to get the sum to show in that view?

We have a rather long custom request form. I'm wanting to export it to excel, word, or pdf so we can see all of the fields that we currently have. I can't seem to figure out a way to do that. When I export from the custom form list, it is just the name of the form, no detail.Thanks!

I have a project level report that I am wanting to add a 'vendor' field to. This vendor field is captured in an expense custom form. Is there a way through text mode to add that to a project level report? The other issue is that there may be multiple vendors for a project but we would want to onl...

Hi Doug,Thank you. That is a great suggestion and I will add that in to the syntax too. Thanks for the suggestion! Heather