-
Linking new entries to a previous entry - tracking attendance
Hello, I am trying to figure out a way to track the attendance at the multi-week classes that our health educators teach. I'm trying to set something up so that they are sent a link to a form every week (or whatever frequency their class is) and so that they don't have to enter static information every time (location,…
-
Using Nested If and Formula to Set Value of Field
I'm trying to set the value of a field using an IF statement based upon a calculated number in a column called "Tier Score". =IF ([Tier Score]@row <= 17, "Tier 3", IF ([Tier Score]@row <= 25, "Tier 2", IF ([Tier Score]@row >= 26, "Tier 1"))) I keep getting UNPARSABLE. Thanks
-
Project Plan - Start/End Dates, % Complete and Duration columns not updating.
Happy Friday! Appreciate your feedback, please! Here's a pic from my Project plan (created from the PMO Template) showing the column titles and rows 1-6. Rows 3-6 are in the first phase of the project (under row 2, grey). These are the only completed tasks out of 39 for the entire project. the rest are not started. I'm…
-
Show Off your Smartpets
Many of you have shared beautiful photos of your pets in the Community, and it is always a joy to see them! That’s why we decided to create this space for you. Introduce your animal friends, show off their new outfit, share your favorite stories, or anything else you like. Everyone is welcomed - from cats, dogs and birds,…
-
Increase sheet row and column limits
Hi Guys, What is the possibility to increase the row (20 000) and column capacity? I'm working for a company that headcount surpasses the 20 000 mark which makes it extremely difficult to utilize smartsheets, which we really want to do. This would truly make a huge difference in building a database etc.
-
Need to look for $99,000-$249,000 in Metrics Sheet. Can't find formula error
Need to look for $99,000-$249,000 in Metrics Sheet. Can't find formula error. =COUNTIFS({1. Case Queue Range 6},>"$99,000",<="$249,000")
-
MAX(COLLECT({Range 1}, {Employee Range}, @cell = Employee@row))
This discussion was created from comments split from: INDEX MATCH with MAX.
-
Workspace Shared to panel
Hello, Would it be possible to reduce or even hide the panel showing who is shared to a Workspace? I'd like to see the names of the content within the workspace far more than who the Workspace is shared to. If the Workspace Shared to section could be minimized, that would be ideal. Thank you for your consideration, Lisa
-
New Window pop-up option
A recommendation I would like to make is adding a feature under widget behavior. When connecting a Smartsheet under widget behavior, it would be nice to have a check box or a toggle switch that asks if you would like a new window to pop-up whenever the widget is clicked. A new window pop-up is allowed if you copy and paste…
-
Need help to auto populate a formula to display a number
It is simply EYYWK## -YY= year (e.g., 24 for 2024) -WK=week (e.g. 15 for right now. The 15th week of the year) -##=sequential e.g., 3x E-runs have been created this week, so the last "Full# in the book is E241503