-
If Statement Help
I could really use some help! I am trying to write an if statement. Based on: Due date being < = -68 New entry is "starred" Entry 1 = "yes". I want it to be complete if it meets the conditions listed above and incomplete if it doesn't meet those conditions. This is what I tried: =IF([New Entry]@row = 1, [Entry 1]@row,…
-
Index Collect with an IF and a Join?
Good morning all I'm after help with a complex formula concept. FYI these are not live data sheets just moc ups. Data Base Sheet Metric Sheet Bellow is the formula im currently using to pull contracted orders across to a second Metric sheet. =IFERROR(INDEX(COLLECT({DATA BASE | Customer}, {DATA BASE | Start Date},…
-
Missing Reports on a Dashboard. Then suddenly appears after refreshing. Then missing again.
Hi everyone, Have you experienced being haunted by a Report widget within the dashboard? Our Clients were complaining that some tables within the dashboard suddenly went missing, but after refreshing, it will appear and then gone again. This is my first time encountering this, and I've already raised a ticket to Tech…
-
Salesforce Connector not pulling in related object values
Hello, I am using Salesforce connector to populate a Intake form in Smartsheet. I am able to pull in all Opportunity fields but we have a Discovery Questionnaire object (via Lookup Summary field) related to the Opportunity and I can't get those value to populate. I see them as being able to map but am unable to populate on…
-
Smartsheet & Outlook Invites for meetings
Is possible to create an automation where from a sheet in Smartsheet we send and "order" to Outlook to send an email invite to specific email address for joining a meeting? Or sending the same from Smartsheet directly but blocking outlook calendar for the person who receives it?
-
Change date format of attachments
Looking to be able to change the regional date format of attachments on sheets. This has previously been possible on a day-month-year format, but has now changed to a month-day-year format where it is unable to be changed to our preference.
-
Smartsheet & Outlook Invites for Meetings
Automated emails where from a sheet in Smartsheet we send and "order" to Outlook to send an email invite to specific email address for joining a meeting? Or sending the same from Smartsheet directly but blocking outlook calendar for the person who receives it?
-
How do I get this to work as I intend? Health Symbol Formula - Red, Yellow, Green, Gray
Hello, I've worked this many different ways, but cannot figure out how to get this to work. When I reordered the On Hold to the front, I finally got that working but then I saw the Completed < Today was red. I'm sure I'm missing something here and am fairly new to this. Will someone offer a little guidance to point out the…
-
Document Generator inconsistent Font
I am working on a process where we are bringing in two different signatures, but we need the font to be the same for the signature. Both fields are changed in Adobe to be the same font, but one is the font and the other is a regular font. We messed around with it and we were able to get it to bring in two different fonts…
-
Auto populate dates based on new dates in a work back schedule
I have set up a work back schedule with predecessors. I have new dates for some of the tasks, I don't want to manually change each date. What would be the best way to auto-populate new dates in a new column without changing the old dates? Is there any formula/ alternative option for this case? Thank you in advance.
