-
ISBLANK Nesting
Good Morning All, I am new to Smartsheets and would like some assistance on what I thought would be straight forward and I know I am missing something basic. So the formula in English: Is DATE 2 Blank YES - then NETDAYS between DATE 1 and TODAY in DAYS NO - the NETDAYS between DATE 1 and DATE 2 in DAYS So I thought it…
-
How to write Nested IF statements each on separate line?
Hi, I have this nested IF statement that I would like to have each IF condition on a new line for easier reading and to follow coding best practices. Here is what I have now: =IF(COUNT(CHILDREN([Task Name]@row)) > 0, IF(COUNTIF(CHILDREN(), "Red") > 0, "Red", IF(COUNTIF(CHILDREN(), "Yellow") > 0, "Yellow",…
-
No longer receiving reminders/notifications
I have not received reminder emails or notifications in the app for any reminders/alerts since 5/22/2019. I have checked my notification settings, my spam folder, I keep running tests, and so far I can't find an easy solution. I've attached screenshots that show my notification center, card view showing active reminders…
-
Using multiple working days/resource schedules in the same project
Hello, As a construction PM, one of the functions I use most with SS is the Gantt style programming. I have multiple crews on the same project/in the same sheet, but the issue I have is they each have a different working schedule - for example night shift is Sunday to Thursday night, day shift is Monday to Friday, and some…
-
Formulas
Hi, I have a formula that works perfectly in Excel but I can not get it to work in Smartsheets. I am having issues finding corresponding functions in Smartsheets. This is the formula and screenshots show what I am getting from them.…
-
Parent Date Roll ups - Possible for two sets of dates?
I have a head scratcher here, thanks in advance for any help that anyone may have. My scenario is this, I have project plans that have two sets of dates, one is estimated dates and the other is the actual dates on the project tasks. In my project settings the estimated dates are linked to the dependencies. When I enter in…
-
VLOOKUP for multiple options influencing Gantt chart
I have a sheet that uses Gantt chart data to show assignments on a calendar. The persons assigned are all in a "Name" column that is a drop down with all the employee names on them. Next to that are start and end date columns that then show a bar range in calendar view. The employee's name will only appear in the bar in…
-
Dashboard Gantt for Extended Period Task Prevents Display of Current Dates
For a leadership dashboard, we have a report with a list of current projects. We want to display the Gantt chart on a dashboard. One of the projects began on 8/4/2015. The Gantt timeline begins in August 2015 and can scroll to the week of March 17, 2019. Given that it is May 23, 2019, this is a no-go. Workaround ideas? My…
-
Adding a grid to a Form
Hello, I'm wondering if there's a way to add a grid to a Form to collect data when multiple names, emails and job titles are submitted. Currently we ask people to submit a PDF form to us that has an embedded table where they list the staff who have taken a training. The table headings are: Name, Email, Job Title. Sometimes…
-
Testing multiple due dates against completion dates
Hey Community members I have a sheet that is tracking reporting compliance. Most of the reports only have ONE due date (typically reported annually ie 30th June), but there is a number that requires monthly and quarterly reporting. To allow our users to enter up to 12 dates for a reporting cycle we have 12 fields to…
