-
Webform
I have information populated on a sheet via a webform, and I need a value added in a hidden field so that the one cell is populated with the name of another cell but when the form information is added it adds an apostraphe to the beginning of the formula.....below is exactly what I am getting this is the formula =[Task…
-
Why is this #UNPARSEABLE??
Hi all, don't understand why this is ##UNPARSEABLE.. =IF(ISBLANK([Actual Finish Date]39), "", IF(ISBLANK([Actual Start Date]39), “ERROR1”, IF([Actual Start Date]39 > [Actual Finish Date]39, "ERROR2" , “” ))) Really appreciate if someone can tell me why... Thanks -dp-
-
Best way to manage Projects, Ad Hoc Tasks, and Reoccurring tasks
Hi community. I'm new to SmartSheet - and we are getting our team of 6-8 set up to try and manage our larger Projects, Ad Hoc Tasks each one us handles, and some of the larger reoccurring tasks (like writing / sending monthly email newsletter). We probably have 5-15 large projects and 50+ smaller ad hoc tasks. Any…
-
Is there a way to make the linked cell symbol (blue triangle) larger?
Is there a way to make the linked cell symbol (blue triangle) larger? I fell that they used to be more visible.
-
Find Mobile Forms
I'm starting using the mobile app and I can't find my forms. Is there a way I can do this? I have multiple users who need to view the forms off mobile; am I missing something? Veronica
-
Enhancement Request: Add Filters to Column Menus (special columns)
With the 2018-01-17 release, we can now filter on attachments/comments/locked rows (yes or no). Please add the first two to the associated Column Menu for those columns. Also, add filters for the Icon column (resource issue, reminder, pending UR) and add that to its Column Menu too. If the Filter Menu is not shown, adding…
-
Formula is changing after a date sort
Once my data is in the appropriate cells I want to perform a sort by Due Date. When I do this the formula =SUMIF($Equipment5:$Equipment171, "VUTEK", $Tue5:$Tue171) Changes to =SUMIF($Equipment16:$Equipment171, "VUTEK", $Tue16:$Tue171) Thus not including any data from rows 4 thru 15. I have locked the row with the formulas…
-
2 things. Referencing another sheet and trying to autofill information on separate sheet. Calculate
I have a sheet for a department and we are keeping track of material cost when an employee has to redo work. I have a graphics sheet with a weekly plan. I have one column with checkboxes to assign a task as a redo. When the box is checked, I want it to auto fill information on this sheet onto another sheet. I have tried…
-
Dropdown Formula
I have two columns, Status and Done. Status is a drop down with the options: Backlog, Working On It, Fast Tracking, Waiting on Someone, Done. The Done column is a checkbox, 1 or 0. I have already inputted the logic where when the subtasks are "done" (1), the parent automatically switches to "done". Here's that…
-
SUMIFS Formula
Novice Smartsheet User Trying to calculate the Sum of the numbers in a Column with Conditions from 2 other Columns. I keep getting the #UNPARSEABLE error. Condition: Sum up the numbers in Story Points when the "Sprint Name" column matches a certain value and "Team" column data matches a certain value. Both "Sprint Name"…
