-
Export to MS Project
Hi, When I export a sheet with a Gantt chart to MS Project, I loose all the data on task duration, dates, predecessors, etc. Is there a way to export keeping this project information intact? Thanks, David
-
MacOS and Firefox - Gantt Scrolling Not Working
I have a MacbookPro 2017 and I am only using the built-in trackpad. No extra drivers for Logitech or any other input devices. When using the latest version of Firefox, it takes 2 or 3 tries to get the Gantt to scroll horizontally or vertically. And when it scrolls, it is very jerky and slow. I have the exact same browser…
-
Future Date Calculation
Hi I'm trying to convert an Excel formula to Smartsheet formula: Excel formula =[Installation date]4+(365*[Warranty Expiry]$3) Aim is to give a future date when the warranty will expire x years after the piece was installed. Thanks
-
Countifs same column different criteria
Hi I'm trying to count the items in the in one column if they are not equal to criteria in another column. May someone assist. This is what I have so far. =COUNTIFS({FDA Submission 2019 Range 1}, "DE Novo", {FDA Submission 2019 Range 2}, OR(@cell <> "Approved", @cell <> "Rejected", @cell <> "Withdrawn")) However everything…
-
Tab options in One Sheet
Good Afternoon! I was curious to know if SS offered something similar to Excels "Sheet Tabs". For Example, instead of jumping back and forth to different Smartsheets, is it possible to jump back and forth without ever really leaving the page you're working on ? Please see the attached file for a better understanding of my…
-
Harvey Ball formula that reads across and produces cumulative
Hi All - I would like a formula that reads across vs vertically - here is my vertical one. I need the same thing but read about 10 columns status to then come up with an overall status meaning if there is 1 red, 7 yellow and 2 green then the overall cumulative status is red (lowest common denominator) Vertical Formula:…
-
Is there a way to use SumIF to add values in a column that match a specific text string in adjacent
We are building estimate sheets using a hierarchy based on Construction Specifications Institute's organizational coding system. I have rows nested using multiple parent / children. The top level is the CSI Division, which has children rows with specific categories within that Division, and each Category line has nested…
-
Mandatory Fields
Is there a way to make "Send me a copy of my responses" mandatory/a required field?
-
NETDAYS based on IF statement
I'm trying to use a NETDAYS function to determine how many days overdue a payment is, but I only want to display that number of days if a column named 'Status' has the value 'Client payment pending'. The function I'm trying to use is =NETDAYS([Date Sent to AP/CR]398, TODAY()) but I don't know how to work that into a…
-
Convert multiple text dates to a date field in a single cell
I have contract information entered into my sheet via Web Form. The users are allowed to enter multiple products in at once but asked to keep information pertaining to them in the same sequential order throughout the form entry. I am looking to see if it’s possible to take multiple text dates entered in a single cell and…
