-
How do I count the entries from a column from another smartsheet?
I need to count total entries from another column from another smartsheet minus out scope criteria. i.e. 1st Smartsheet, column 1 Title “Total Sites in Scope” 2nd Smartsheet, Column 1 Title “Site IDs” that has entries. Column 2 Title “Order Status” dropdown option “out of scope” Solution: 1st Smartsheet, column 1, cell 1…
-
How do I make the cell to change data after other cell is populated?
I have sheet 1 with the rows below with formula in: LAN Migration Ready =COUNTIF({sheet 2 name Range 10}) LAN Migration Ready Approved =COUNTIF({sheet 2 name Range 11}) LAN Migration Scheduled =COUNTIF({sheet 2 name Range 12}) LAN Migration Complete =COUNTIF({sheet 2 name Range 13}) Sheet 2 I have: Each row represents a…
-
Capacity vs Demand Utilisation RAG Column
Hello, I'm looking to create a capacity vs demand utilisation RAG Column where it will appear with Red, Amber, Green for the following rules: Green: Total Q1 Capacity = Q1 Total Demand Yellow: Total Q1 Capacity > Q1 Total Demand Red: Q1Total Capacity < Q1 Total Demand Kind Regards, Luke
-
How to identify the first date and last date from another smartsheet column?
I need to identify the following: Smartsheet 1, Column Start Date, row 1 cell 1 and Column End Date, row 1 cell 2 (need to obtain from smartsheet 2) Smartsheet 2, Column Start Date and Column End Date have several dates. Smartsheet 1 needs to identify the earliest Start Date and the latest End Date from these two columns…
-
Getting last login information via API call
I have looked at the documentation for the API call but when I am hitting the users endpoint: https://api.smartsheet.com/2.0/users?include=lastLogin,source&includeAll=true it is not including the lastLogin information. If I hit: https://api.smartsheet.com/2.0/users?include=lastLogin then I will receive it for those users…
-
Conditional Formatting not applying consistently
I have a sheet with conditional formatting rules so that if there is a "0" in a cell the text will be gray and if there is a negative number it will be red. If I close the sheet and then open it again the conditional formatting does not show, but if I go into the setting and basically pretend to change the formatting it…
-
Count distinct values within cell
a
-
Resubmitting a Form With New Info After Declined Approval
Hi All, Our department is looking to produce a Training Request form for our staff. How do we set up an automated workflow where it'll allow the original requester to edit the training request if it has been declined by the manager? For instance, the manager may know that there's a less expensive training in Los Angeles,…
-
Flag warning if date is after another within same column
Hi all, Currently having issues with this: I need to find a way of flagging a warning (that'll just say "WARNING") in the thirteenth row of the date column if any of the dates in rows 2-12 are after the date in row 1. I am also struggling to find a concise way of flagging a warning in row 14 if there are any duplicates in…
-
Lookup Columns Between Sheets
Good day all I'm a newbie on the community. I'm trying to deal with a scenario which I thought was very common and assumed Smartsheet would have an easy way to deal with. The scenario is: we have a very simple sheet for managing customers. This sheet includes a customerID, business name, primary contact person, postal…