-
Is anyone having data sync, cell link, calculation issue
Since yesterday, we are experiencing the data value errored out and a couple of minutes later, it fixed itself. Does anyone have the same issue?
-
Timeline Duration in Months
I'll never understand why Smartsheets doesn't have basic features. Is there no way to schedule durations by month in a Gantt chart? Is this a joke? I don't understand how you guys want to be the excel of project management and not have some sort of date function like EOM or EDATE.
-
Converting military time to standard time
Hi All, I have a bit of a different ask than what I saw already listed here. 1. I need to subtract a certain number of hours from a military time format and add it to a third column. Please let me know if you can assist. Thank you!
-
Days to Completion
I want to modify this formula: =IFERROR(IF(Status@row <> "Complete", NETDAYS(TODAY(), Finish@row), "N/A"), "N/A") To also include if Status<>"Not Needed" or Status<>"Phase 2". Thank you.
-
Impossible to visualize groupings more than 2500 rows...
Hi, Im searching over the internet a variety of things (data) from a variety of types (countries, format, source, etc) and some of them are validated (true) and some dont (false) and inserting this information in a Smart Sheet page. On the other hand, I have this REPORT, reading from that sheet i have just mentioned, and i…
-
REPORT NOT ABLE TO VISUALIZE MORE THAN 2500 ROWS
Hi, I have this list of entries, (each one has his ID) stored in a sheet, some of them are validated, some not. I have this other report where all validated IDs are shown, grouped by certain column (country). Once i have arrived to more than 2500 entries the report states: Now the question is, please tell me i dont have to…
-
Problems calculating the difference between two dates
I'm trying to do something that should be very simple. I have two date columns, both are column type Date. Both columns use a cell reference to get the date. If I use =NETDAYS([Current End Date]@row, [Approved End Date]@row) I receive an error, #INVALID DATA TYPE If I use =([Current End Date]@row - [Approved End Date]@row)…
-
Index/Match or Index/Collect for multiple criteria including a checkbox
Need a formula to return the data from another sheet where the system generated auto number matches and the check box in the "Most Recent" column is checked. Matches: Auto No (column type: # Auto Number) from both columns Checked: Most Recent (column type: check box) from reference sheet I've tried several versions and in…
-
Dashboard Barchart adding 2 extra data points 0 and 2 on every chart. When hover it does not show data total
I have a report that contains 2 types of data. Birdcage and Skid. For each one of these I want to show Quantity that shipped on one bar and quantity that is left to ship on a seperate. If you minimize the birdcage data you will see skid date the same way. Data is grouped by Type (birdcage or skid) then summaried by Qty…