-
Daily Update Solution without the need to open the sheet, use Zapier, or similar
Hi everyone, Happy New Year! I hope you're well and safe! I've developed a way to use the newly released Record a date feature to update sheets with today's date automatically without the need to open it or similar. 1. Add a so-called helper column. (Date). We can call it Today Helper and add a date before the current day.…
-
Dynamic dropdowns - Waterfall request
The Contact List, Dropdown (Single Select), and Dropdown (Multi Select), are useful tools to control data entry. The problem is they require a lot of maintenance. Through Bridges, we have a sheet that is populated with information from our ADP. It contains all of our employees. Using a Contact List column and selecting the…
-
Formulas Not Automatically Updating
Hi, I have a sheet with formulas in multiple columns. Non-licensed staff are able to add rows of data via a form, and also make updates to existing rows of data via a dynamic view. They view the data via a report. I have this same set up running for 33 separate locations, however one location has been indicating for the…
-
Improve Activity Log to include API Detail
When Bridge queries a sheet, it will be indicated as such within the Activity Log. However, there is no transparency as to which API workflow this is coming from, so any kind of quick troubleshooting is impossible. Smartsheet technical support also is unable to see this information from their side. The Activity Log should…
-
Sheet setup for scalable data
Looking for a best practice to set up a scalable (target vs. actual, month-over-month) sheet - There are 15 specific varying metrics (e.g. numbers, $, %) collected monthly by different people. Each metric will require both actuals for the prior month and a target for the next month. I would like to show both monthly…
-
Hello - looking for help creating my sign in and out form.
I am fairly new (yet familiar with the possibilities available) in Smartsheet. I am in the process of creating a tracking form for my job to see anytime a device is in use and which employee is in possession of a shared device and what location they are working at that moment. I am collecting the employee's name and ID…
-
Lock single cell
It would be very useful to lock a single cell. I see it's been asked many times on the community but I did not find anyone submitted it as an idea
-
Frustrated
Hi All - I am new to Smartsheets and I'm attempting to teach myself as I go. I created a sheet for every department that also has a form attached with specific questions to be answered. Department managers will use the form link provided to input their information daily. I am struggling with how to get these metrics to…
-
Workflow Automations being sent out on a different levels of data within Intake Sheet
Hi all, I'm trying to solve an obstacle I came across when building Notifications in the Intake Sheet. Let me shortly describe what I'm trying to achieve: Above is an example of the Intake Sheet that will act as a scenario for my question. I have a Primary column, which is a combination of different values from two columns…
-
COUNTIFS formula not functioning how I expect
Hello, I am expecting this formula to count the number of cells in the "FND Prepare" column that have a certain name in them, where the cell on the same row in "Prepare Status" is not green. =COUNTIFS([FND Prepare]:[FND Prepare], HAS(@cell, "NAME"), [Prepared Status]:[Prepared Status], (@cell <> "Green")) Does someone have…