-
Pull a calendar
Hi-- so, I have a series of columns representing various tasks. And then I have a series of rows representing various projects. I enter various dates into the corresponding cells (eg Project X and Task Y will occur on such and such date). What I want to do then is on a separate sheet list all of the dates in the year and…
-
Connect Action log (dates) with a project sheet dates
Hello; I am currently working with two sheets, one is the project plan and the second one with an action log corresponding to one of the phases of the plan. I have an issue when I am trying to connect log date & due date of each of the actions of the action log, with the finish date of some of the activities from the…
-
sumifs as Cross-sheet formulas
Has anyone had success using the sumifs function as part of cross-sheet formulas? I have been giving it a whirl and haven't had much luck. I am not sure if it is even possible, and if is then I'm not sure what I'm missing.
-
Using Today formula in date field has limitations
Hi. I just wanted to find out if perhaps the =today() function does not work when using a sheet with begin and end dates and dependencies enabled. When I try to enter the function, it only shows the actual function statement and not today's date. However when I use this function on a sheet with only one due date column and…
-
Multi Formula/Sheet Help
Hi Been struggling with this for ages, I can get the two elements of this formula to work separately but not together - I hope the below makes sense! :) I am trying to get a formula to: A) Search a column on another sheet to see if a reference number is present The below works but gives me the total count…
-
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?
