-
If statements with multiple conditions
Hi, Hoping someone can help with a formula I am struggling to get to work for a specific scenario. I have a "phase column" in my project plan which looks at various parent rows for my project phases, i.e Discovery, Design, Build, Implement, Benefits realisation. The formula assesses the status of these phases, so I can…
-
Last Working Day of the Month
I have been wracking and wrecking my brain trying to figure out a formula that will go ahead and automatically display the date of the last work day of the month taking into account weekends and holidays that will automatically calculate based on today's date. Any ideas?
-
Adding time durations as actual numbers
Hello, We're trying to use Smartsheet to report on music details. It would be very useful to take the durations of music tracks (formatted either as mm:ss or h:mm:ss) and add them together together for a total duration. How would we attempt this?
-
Showing Errors in a formula
When working with a formula, some errors do happen and the formular doesn't work. Does smartsheet have a feature like excel which would show a part of formular that is missing something or has a problem? Also in excel, before you hit Enter in a formula, you could highlight part of an argument or formula and hit F9 to see…
-
Importing Excel Spreadsheet with embedded formulas
Does anyone know if you can import a Excel spreadsheet into SmartSheet with embedded formulas and formulas linked to other sheets in the same Excel file without having to re-create the formula within SmartSheet?
-
Why doesn't this SUMIFS working?
I get #unparseable. =SUMIFS(Effort Hrs:Efford Hrs,Assignee:Assignee,"Easton",Sprint Week:Sprint Week,"32") Effort Hrs = Hours worked Assignee = the person Sprint Week = the wee it is done
-
Using INDEX/MATCH to create sheet with subset of data from another sheet
I have a sheet that lists hundreds of inventory items. The sheet has columns with checkboxes indicating if a given item is included in a specific shipment type. I'd like to create a new sheet that populates a list of the inventory item numbers for every instance that checkbox is checked for a given row on the original…
-
Excel Formula Error
Hi All, I've referenced the forums for help and thought someone might help me with the "unparseable" error I am getting. We are trying to do complex formulas: =COUNT(IF(FREQUENCY([Listing Key]2:[Listing Key]20)>0,1)))) The "[Listing Key]2:[Listing Key]20" reflect the chosen cells to crunch the formula. Attached is a…
-
Hyperlink to external drive
Hi all, I'm looking for a way to enter a hyperlink from another local shared drive in a Smartsheet cell. Is this somehow possible? Thx for your help! Warm regards, Gonnie
-
Web form populates parent/child relationship through category
Hello, was hoping to get some help on an issue i am having .. we have an inventory control sheet .. we would like to use a web form(s) to not only take out something of the inventory but to also add something to the inventory. I added a Category column and that is reflected in a dropdown list that matches all of the…