Sign in to join the conversation:
Hi,
is a column with the same name from several sheets can be joined on a report? for example the assigned to column ?
thanks !
Unfortunately, they can't. One possible workaround could be to join the information in another column before the report.
Would that work?
Have a fantastic week!
Best,
Andrée Starå
Workflow Consultant @ Get Done Consulting
that's weird though, I am pulling data from multiple sheets, all of Assigned To (contact field) are coming into one except for one sheet that has the contacts on a separate Assigned To, which doesn't look good in a report.
Any idea what the issue is ?
Is one of them a Multiple contact field?
Andrée
Hello, I'm working through the writing formulas optional activity and in the 'Nested IF function - Progress Column' task it directs you to put in the following formula '=IF([% Complete]@row = 0, “Empty”)'. However, when I put this formula into the spreadsheet, '04a_Marketing Request Tracker - Formulas', I get an…
Have any of you created a Smartsheet that would show the savings for a project by the month? In other words, if I saved $1200 annually and the project ended in say March, then the savings would go $120 per month, Mar 2025-Feb 2026. I have done it on Excel sheets manually, but I think there should be a way to do it with…
I have had approval workflows and notifications built into a couple sheets for about a year now. In the past month, I am getting a lot of feedback saying people did not receive the email request for approval or notification email. It isn't all the time, just sometimes and there does not seem to be a pattern on which ones…
