-
Turn average working days to projected date using WORKDAY()
The basic ask is to calculate a projected due date based on historical data and duration that a certain task takes. So if x, y, and z parameters are checked, it will find the average amount of time (from a different sheet) that those parameters take and then calculate a suggested due date. I want to use WORKDAY(), but am…
-
Why is my formula UNPARSEABLE? Is it because of Dropdown Dependency?
It's a long formula - I want to make the number of starts in the "Current Status" column dependent upon the selection in the drop down from the "Contract/Grant Status" column: =IF([Contract/Grant Status:]1 = Submitted, "Empty", IF([Contract/Grant Status:]1 = Assigned, "One", IF([Contract/Grant Status:]1 = ELD Review ODE…
-
count if formula help
Was hoping to get some tips on the following use case. I set up a Smartsheet to track all my organization's training accreditations. This includes (student, assigned coach, product course, accreditation level, status, etc.). I want to create a formula that counts the number of open engagements per coach. This will help me…
-
need a function to set permission to one cell,or one column
need a function in smartsheet to set permission to one cell,or one column, it means, the viewers can view most of the datas in the sheet,but one or two cells,one or two columns,take the classified column within revenue for example, the datas inside of this classified column just can be viewed by owner and admins, the…
-
holiday period
Hello, I'm trying to add holiday (complete shut down for 2 weeks) period to my project sheet. I've done it in project settings ect. but it is not showing on my sheet. The project should be that much longer and I was expecting to have a separate bar to appear showing holiday period cutting all tasks started and putting them…
-
Extracting Numbers from a Cell Containing Both Text & Numbers
Hi All - I am uploading a .csv file into a Smartsheet sheet. One of the columns within the .csv file is formatted to contain '$ prior to the numbers within the cell (so when opening in Excel, it will not convert the cell contents into scientific notation). I need to remove the '$ text from the cell, so I can sum the value…
-
Cell Link Capacity
Hello, For 2019, is there any chance of the cell link capacities increasing? Does anyone have any insight to this?
-
Help with dashboards
Hi, I'm Creating my dashbord to manage some sheets. I've already included the widgets but i can't include a standard filter for each sheet. (like in the classic edition page). All sheets opens with filter off. How can I set a standard filter? Thanks
-
Formula Sumif Range w. Web Form
I have a sheet where I am using a Webform to gather data. Issue is the Sumif formula I have at the top of my sheet will not include the added line entries of the webform entries. =SUMIF(Task2:Task4, Task5, Hours2:Hours4) New Webform entry is line 5, Formula will not automatically capture that added line. Please help.…
-
Formula to count values in a column
Good evening VERY NEW to smartsheet. I am creating a metrics sheet for data we want to capture on another sheet. How do I get the QTY of "beam" counts in this column? Thank you