-
Bridge Javascript/Call API & Control Center
Hello all, I have had some success with using the Smartsheet API using the PythonSDK. I am currently using Control Center to create some projects, but they get created in a workspace instead of a folder within a workspace. I have had some success with using the Smartsheet API using the PythonSDK to do something similar, so…
-
Weird issue - COUNTIF Date Cross-sheet Reference
Hi - I'm doing a very simple cross-sheet reference for a count of dates and it's not working. Sheet 1: Date column has a series of serial dates. Column14 has a formula that is not working. Sheet 2: This has a Date Completed column. The formula in Sheet 1 in Column 14 is: =COUNTIF(Date:Date, {BPD-DateCompleted}) - ...where…
-
Cannot make a formula with a cell reference to another sheet work as expected.
I'm trying to count the number of Blocker (priority) tickets for a specific Business Unit. This is the formula that SHOULD work: =COUNTIFS({BU}, [Business Unit or Dept]:[Business Unit or Dept], "JM", {Priority}, [Priority]:[Priority], "Blocker", {Ticket}, [Jira Ticket #]:[Jira Ticket #], <>""). I have validated that the…
-
Logic type table help
Can anybody suggest a way to do this. I have it working in excel, I can't seem to get it working. I have this excel formula that works. =IF(AND(A2="OT", B2="UNDER"), "LOW", IF(AND(A2="OT", B2="OVER"), "MEDIUM", IF(AND(A2="LATE", B2="UNDER"), "MEDIUM", IF(AND(A2="LATE", B2="OVER"), "HIGH", "") ) ) ) I want to compare the…
-
Children Parent % not calculating
Hello, I'm trying to build a sheet that calculates a percentage off of a Status column, but the column is not returning a percentage and the =AVG(Children) section. This is my mess of a formula =IF(IsParent@row = 0, IF(OR([Rally Status]@row = "Submitted", [Rally Status]@row = "Acknowledged", [Rally Status]@row = "Not…
-
Automation Workflow Step Through Mode
Create a mode that allows administrator to step through an automation workflow. Feature should allow stepping through one step at a time and being able to go back to the sheet to see the result to that point. Also provide method to select a point in the work flow to stop the workflow at a specific point while in this mode.…
-
Is there a way to remove all source sheets (to a report) at once?
Hello Smartsheet Community, Is there a way to remove all the source sheets at once other than delete them in the source sheet section one-by-one?
-
Auto-calculate a date but round to nearest weekday
I a creating a smartsheet that is calculating several milestone dates based on a single event date. This is the formula I'm currently using to calculate a milestone date 8 weeks prior to the event date, based on the event date being manually entered in the [Milestone Date]16 cell. Is there a way to make this return the…
-
How to calculate the days in que from a form?
Do I need to add a column to record the date of each approval?
-
Countifs multi select column and year column with contains
Hello! I have a multi-select column from which I am able to get a summary formula to count correctly, but every attempt I've made to account for the year from a second column has returned errors of some kind. The Year column has a formula in it as well: =YEAR([Contract Fully Executed Date]@row) This is the formula that…