-
Help: #INCORRECT ARGUMENT SET
Trying to figure why this isn't working...the first two formulas seems to work but adding the third gives me the #INCORRECT error...Please let me know what I did wrong? =IF(ISBLANK([1st PRODUCT_OWNER APPROVAL]@row), "", IF(ISBLANK([2nd PRODUCT OWNER APPROVAL]@row), "", IF(AND([1st PRODUCT_OWNER APPROVAL]@row = "APPROVED",…
-
Terminating a formula once criteria met
Hi! I am working on a sheet that has a basic if formula to populate the Red, Yellow, Green symbols. I want to be able to have the cell not change or have the formula run once the line is shown as "Red." My formula is =IF(AND([Scheduled End Date]1 < TODAY(), Status1 <> "Closed"), "Red", IF([Scheduled End Date]1 <> [Actual…
-
How can I use the SUM function in a column, but only add/account for numbers that are in child rows?
Is there a formula that I could use to SUM numbers in a column, but NOT accounting for values that are in parent rows? The formula would go on a sheet summary; the reason not to account for values in parent rows, is to avoid duplication, since they are a reflection of the information in their child rows. Thank you!
-
Project Management: Automating Timelines Across Multiple Projects/Sheets
Before I go into specifics, maybe the simplest form of my question is: can I somehow mimic the functionality of LiquidPlanner's "Smart Schedules" in Smartsheet? (Just to clarify, my company doesn't have LiquidPlanner nor does it plan to, it's just the only product I've heard of that has this functionality out of the box.)…
-
Automation - Changing data on feeder sheet will update recipient sheet too?
Hi there, I was trying out the automation function to link important dates from several project plans to one central location that will act as a calendar. Automation is: If "Add to calendar" = checked, copy row to calendar sheet. The premise works well, but in cases where the date changes on the primary sheet, this does…
-
Is there a limitation for current user selection in reports?
Hi, I have not found any info on this in the community or in the help sources. Before I start to implement reports and dashboards with the "current user" feature, I would like to know if there is a limit to the count off concurrent users accessing the same report at any time? Greetings Stefan
-
Dashboard Report Widget: Columns Content and GANTT aren't in the same line
Created a report and added the report via widget to the dashboard. Realized, that the lines are not matching....Content line height is obviously different to the GANTT line height. The report itself looks good and correct - the change is only when presenting in the widget. Is this a 'feature'? Thankful for any help
-
Countifs across multiple columns
Hi I want to count how many times Name=xx, has Green/Yellow/red balls across 7 columns =COUNTIFS({C-test Creation House applications Range 5}; [Column4]13; {C-test Creation House applications Range 6}; [Column5]12) (the range 5 is the reviewer column, and the range 6 are the 7 columns) It works if I only choose 1 column,…
-
Traffic Light Formula Based on Date and % Complete
Hello, I am trying to create a health status formula using the traffic light: Red, Yellow, Green Blue symbols. I would like the status to update based on the Deadline as well as the % Complete. The second set of conditions within the formula will not return a result. Here is the formula: =IF([% Complete]@row = 1, "Blue",…
-
Comparisons of dates(Committed date,New Committed date & Actual Completion Date)
Hello I have 3 dates column in smart sheet i.e Committed date,New Committed date & Actual Completion Date I need to compare these dates like if Commited date is> New committed date then i should get some color & the same way if committed date>actual completion date then i should get color & the same if New committed date…
