Sign in to join the conversation:
Any Chance of adding this type of Functionality to Smartsheets: https://www.codeproject.com/Articles/712335/Followup-DNS-Lookup-and-Ping-in-Excel
My guess would be no.
What you link to is VBA code, not a standard feature of Excel. You could reproduce this using the API, though.
Craig
I have a sheet where it have some formulas which works on present date. Because of using today function in the formulas, the formulas are not getting updated until I open the sheet and click save.
I'm trying to get a formula for a sheet summary value to calculate average duration of rows where Risk Type = "EDAM Risk" and Status = "Resolved - Mitigated" or "Resolved - Decision." Assuming: Duration is in a column named Duration Risk Type is in a column named Type Status is in a column named Status I've been using the…
I am trying to write a cross sheet formula and keep getting the incorrect argument set error. The formula I wrote is: =SUMIFS({Total Poles}, {Vendor}, "ALLO", {Date}, >=TODAY(-30)) My formula is stating that I sound sum the amount of poles where the vendor column is Allo and where the date column lists dates within the…
