-
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
-
Nested Ifs checking for different conditions
Hello, I am trying to add an additional argument to a formula to check if a cell called "Awaiting Response" is not blank, and if so, change a RYG cell to yellow instead of red, but I am getting either #UNPARSABLE or #INCORRECT ARGUMENT SET. The conditions are all based on when the last response was to a ticket, with more…
-
Summary Fields Behaviour
Hi, I know there is default behaviour in Smartsheet regarding start, finish and duration fields that when a row becomes a parent it automatically shows the sum of the fields of the children below it. Is it possible to define if other columns should have the same behaviour? The reason for asking is that I have another…
-
missing image links in alert someone automation email
Help, We are receiving these emails in outlook 365 with 3 issues see the screen shot below: This seems to be a link to the smartsheet that triggered the automation. Not having the image display looks poor and I do not want the link to the smartsheet on the email (I noticed that the request an approval automation emails…