-
Jumping to a very distant date
Hi everyone I have a Date column in a sheet, wherein I am unable to select / jump to a very old date (e.g. Jan 1, 1980) directly! Need help! Thanks
-
Dynamic push of data into Excel from a Report
Hey guys, I need some help as I 'm trying to automatically import some data from a specific colum displayed in a Report into an Excel spreadsheet and I don't really know how to do it... Here's the steps I've followed in order to have the data displayed dynamically in my Excel spreadsheet : #1 - I've created a report in…
-
Update health indicator formula for tasks that are not due to start
Hello, I'm relatively new to Smartsheet and found the following formula on this discussion board (I can't find original post). I need to update this formula to show "green" for tasks that are not scheduled to start yet, rather than blank. The columns in play are Planned Start Date, Planned End Date and % Complete If task…
-
Running Total in Pivot Table Smartsheet
Hey! I have a form linked to a sheet, and everytime someone replies to the form they are "raising a question". We have people working to solve these questions, and once this is done they change the status of this question to "answered" by checking a box in the sheet. I have the following columns: (1) Form submission date…
-
Incomplete Tasks Count Multiple Criteria
I am trying to account for the number of incomplete tasks for Symbol column types. For example, our 'On Target" column uses the RYG Balls, and i am trying to pull back the number of incomplete tasks based on their color (red, green or yellow). This is the formula i have tried to use based on recommendations from this post…
-
Formulas and Newly Added Rows
Hi, Our case application requires a lot of movement of rows between sheets, and I am having an issue with Formulas not automatically applying to newly added rows which necessitates going into the sheets and manually clicking and dragging the formulas to newly added rows from the rows above (time consuming with multiple…
-
Percentage of certain type of hours submitted
Hi, I'm looking to get a percentage of the total number of hours submitted for a certain category from a drop down list within a time frame. In column A is the date of the submission, column B is the category (e.g. Internal Meetings, HR, General Admin etc.) and Column C is the amount of hours submitted. I would like to be…
-
IF Formula Help
Hello, I am trying to write a formula that checks the box when a condition is met. In this case, when the Job Status is marked as As-Built Submitted I want the check box to automatically be marked. Please note the Job Status column is a drop down: Thanks!
-
Need assistance with a formula
Hello, I am using the below formula to count the number of rows where 140R was checked previous month. This formula was working perfectly fine until this month when the year changed. How can I fix this formula where previous month should be looked at December 2019 for January 2020, but it should look at January 2020 in…
-
Smartsheet Calendar Populates on Outlook Calendar
Hi, If we use the Outlook Smartsheet app, will calendar items on Smartsheet be pushed to the users Outlook? Thank you, Jared
