-
Formula to mark duplicates with a Status of 2 or 3
Hi Everyone, Hoping I can explain this well so that someone out there can help me with this. I have built a solution that is quite complex and moves projects around to 3 different sheets. The intake sheet generates a project ID and then when the project gets to a certain stage, it copies to my Active project sheet, but…
-
Help with "Syntax not quite right"
Hello! Looking for help with this formula for returning "Travel Week Start Date". I want all the children Rows under parent Row 2 to have the value from Row 111 "Start Date" column. I might need an Index/find function, but unsure. I'm getting an error, as shown below. =IF(CONTAINS("WASP", ANCESTORS(Task@row)), [Start…
-
Expand and collapse ALL on the mobile app
I really think it would make things better if I could easily expand and collapse all on the mobile app. It's too much to scroll through on a small screen, and also very time consuming to manually collapse each parent. Especially when it needs 2-5 seconds to save after each change. Please add this feature. I' very fond of…
-
Dynamic Dashboard Template Customization
I'm new to Smartsheets and learning by doing. Currently I'm working with the Dynamic Dashboard template to create my own Dashboard that filters for a given faculty last name, then pulls key details about them from a larger Faculty Information Sheet. I've worked out how to set a form that has a dropdown menu of all of their…
-
Calculate Number of Class Sessions between a Start and End Date
I've tried many variations of formulas, but I am getting #INCORRECT ARGUMENT SET every time. [Session (Days)]: Dropdown box, multiselect, days of week (e.g., "Tuesday", "Monday and Wednesday") Session Meeting (Start Date): Date column, enter start date of course (e.g., 2/11/2025) Session Meeting (End Date): Date column,…
-
IF statement based on values from another cell
Hello, I am trying to add a 4th condition to my IF statement which already has 3 criteria. My current working formula for 3 criteria is: =IF(ISDATE([Reorder date]@row), "Reordered", IF([In stock qty]@row <= [Reorder level]@row, "Reorder Needed", "OK")) I am creating an inventory sheet where if "In stock qty" column is less…
-
IF state with 3 sets of criteria
Hello, I am struggling to get my IF formula to give me anything other than #UNPARSEABLE I am creating an inventory sheet where if "Stock qty" column is less than "Reorder level" qty than to return "REORDERED NEEDED" or if it is greater than reorder level than to put "OK" but the tricky part comes when I add in my third…
-
Notifications sidebar not closing after "reading" items
In my org, several of us are experiencing that the notifications sidebar won't close once items have been read. It has occurred both individually clicking items as read, and using the "mark all as read" function. It has occurred both when the document needed saving and when it hasn't. We're working in different sheets -…
-
User Subscription Model Change - Implications on your business?
We're one of the companies that took advantage of smartsheet's free internal editors, meaning staff with a company email address making changes to reports. Now that user type is changing to a paid seat, we'll go from 2 seats to up to 100. That's a big $$ change. Smartsheet has been great, but this pricing change destroys…
-
how can i utilize when there are multiple selections from the dropdown
This is the formula i am using, but when there are more than one selected from the dropdown it will say #no match =INDEX({chemical rate}, MATCH([Chemical Name]@row, {Chemical Data Sheet chemical name}, 0))
