-
Column Formulas Display Forms
We have a Control Center solution and forms that are tied to RAID logs and more. We have no way on a FORM to automate a project name or ID We would love (like on Card View) for a Column Formula to show static information on the form that pulls from the sheet. OR the option to pull Sheet summary data to the form. This would…
-
SmartSheetAPI PUT
Hello, I want to use the Smartsheet API to update the content of a cell. I have set the API key in the header and tried the following using Postman: PUT Request URL: https://api.smartsheet.com/2.0/sheets/{sheetId}/rows/{rowId}/cells/{columnId} Request Body (JSON): { "value": "test", "displayValue": "test" } However, I'm…
-
How to I calculate percentage progress in sheet summary based on status?
How to I calculate percentage progress in sheet summary based on status?
-
simple COUNTIF Sheet Summery formula
need help with this simple formula for a sheet summary =COUNTIF([IEP Status], "NEW (not signed)", "Active", "Active (Needs Att.)") something is wrong with the formatting I want to count number rows that contain these specific drop down list values. I put the values in quotes but the parentheses from the drop down values…
-
Email automation with PARENT/CHILD data from pivot table
I'm trying to create an output of specific rows of a pivot table to attach/include in an automated email. See below for an example table I'd like to extract from the master pivot table. The "Alert someone" automation allows me to specify which cell information I want to include but does not seem to be able to allow for…
-
JOIN(DISTINCT(COLLECT + JOIN(DISTINCT(COLLECT but how to remove duplicates due to using two formulas
Hi all, First post but I've been reading (and making use of!) many of the queries & answers for a while. Stuck on this one! I have two JOIN(DISTINCT(COLLECT formulas that I am adding together, but sometimes the same person's name will appear twice due to being pulled through by both formulas. How do I prevent this type of…
-
Can I get help with a SUMIF formula for a Sheet Summary?
Is it possible to SUMIF a $ value column, based on a "this month" check box in Sheet Summary? I', using [Value]:[Value] and [This month?]:[This month?] for my columns. Thanks! Jen
-
Best practice question for dashboards and performance
I am in the process of changing everything over to Smartsheet from another package, and am having a great experience so far. I did have a question for experienced users that has to do with best practices when displaying information on a dashboard though: Is it better to have a helper sheet, or use the Sheet Summary for…
-
Multiple contacts in a sheet summary field
Hi, We use control center and we love using Sheet Summary field to bring in certain values from Specific Sheet (using cross-sheet reference formula) then we feed that info to column with column formula so every row will have the same info. We noticed we can't do this for Multi-Select Contact in Sheet Summary if column type…
-
Trying to use SUMIF to Sum one column but only of the items in another column
I am trying to get the SUM of SaaS Value if the value in the Backlog Status column is Active Backlog. Tried this and I am getting unparseable SUMIF([Backlog Status]:[Backlog Status],”Inactive Backlog”, [SaaS Value]:[SaaS Value])