-
Help with Trend Data
I need some help with collecting data for trending. Currently, I have multiple projects with all of their top line data dynamically linked to a Roll-up Sheet. On this roll-up sheet I have data that is calculated from the project Status. Ex: How many projects are Red, Yellow and Green. This works really well for live data.…
-
Calculation from number in a checkbox column
I'm trying to create a column that would allow some groups to report progress as a percentage and some to simply check a box for 100%. I've written my formula, but as soon as I enter a number within the checkbox column I receive the #Invalid Operation error. Any help would be appreciated. =IF(Progress4 = "True", 1 *…
-
COUNTIF Formula Help
Hi I am trying to work out how to do a a COUNTIF formula but I can't get it to work. I have a sheet which contains some payment details and have created an exceptions report that shows invoices that have been submitted but not yet approved which works fine but we want a widget to show a figure of all the exceptions in this…
-
SUMIF Formula Help
Hi I am trying to work out how to do a a SUMIF formula but I can't get it to work. I have a number of columns, one is a fee column (formatted as a Text/Number) and the other is a payment received column (formatted as a date). I have parent/child rows and want to perform this function on a parent row so it sums the…
-
Rounding full numbers (percentage) to nearest 10
I am trying to find a formula to round in full numbers (not decimal places). I have a column that creates a percentage of "investment paid", and I want to round this to the nearest 10. Ie; if the percentage result in the column is 59%, I would like this to display as 60%. And conversely, if the percentage result is 61%, I…
-
Array formulas
Hi, I was looking for using array formula functionality in smart sheet. I need this because i saw that like this i can full fill what i need. Any case, could you please mention if is a way to use array or other solutions in order to perform: - I want smart sheet to show me in a column date, the first date, closest that…
-
Creating a Purchase order spreadsheet
Wondering what template might be the best way to create and share a purchase order system for our construction projects. I want to add links, pictures, pricing quantities etc. Can anyone help with this
-
Series of Checkboxes triggers complete
We're using Smartsheets to track our projects through the production process. We have one sheet that is just a list of the items, with 6 check boxes signaling that portion is complete. When all 6 check boxes are marked "checked"/true, I'd like the last column to automatically update as "completed." I've looked around and…
-
If/And statements
Hi All, So, I am trying to set a trigger flag to be checked when a request is within a certain amount of days and not approved or denied. I would like the flag to trigger a reminder email to the approver indicating the request is imminent and they have yet to approve/deny it. I can't seem to get the IF/And function to work…
-
How do i - If this is checked , then check this on another sheet?
i have 2 sheets to reference first sheet has a confirmed check box column but on another sheet i want it to check a box as a pilot user if the confirmed was checked... is there a way to do this with a formula?Â