-
URGENT Need for help
Hello all, I understand this might not be the real place to ask my question, but am stuck and in need of help. My scubscription ends in a few days, and I am having trouble chenging my credit card details on smartsheet site. I have already submitted 2 support tickets, and written once to finance@smartsheet.com without any…
-
IF and AND
IF(AND(Status1 = "Complete", Status2 = "Complete", Status3 = "Complete"), "All Tasks Complete", "Tasks Incomplete") I would like to know if it is possible to pull out the information from the column instead of a "text" i.e: =IF(AND({5S Audit Score Entry Range 5}=[Cell Name]@row1,{5S Audit Score Entry Range 6}="4", {5S…
-
Kanban style dashboard
Hello, I would like to build a kanban style dashboard from a project plan or any other sheet that contains an action/owner/status. The second step, is I can create this Dashboard to bring together actions from multiple sheets. e.g. I can have action list 01 and action list 02. Bringing them together could show me the…
-
Restrict form dropdown selection to subset of column permitted values
Hi all. I'm trying to accomplish is I want to restrict a form drop down to a subset of the values that the corresponding sheet column permits. For instance, let's say the column in the sheet allows values: red, green, blue. However, I want the form to just allow red and green. I can't seem to make these restricted values…
-
Character limits on Column Properties
Hello, I am new to Smartsheet and require an urgent help on the following issue: I have set up an "Approval" and "Update" workflow for my form, so I receive correct email notifications based on workflow triggers. However, in the email, the questions (column headers) are not fully displayed in the form due to character…
-
need an auto trigger email if i change status of any column?
HI, I have created a row in sheet with open status... i need an auto trigger mail when it changes to resolved or closed... please tell me how to create a workflow for this?? Thanks in advance. Regards, Rakesh.
-
Using a Form to update a Row
I'm wondering if there is a solution to my question. I'm using a sheet to track the difference between two different dates tied to a project, related to my clients. A user fills out Form 1 initially to enter information (Client's Name, Date 1, and Project ID). I would like to prompt that user to (at a later date), enter…
-
11 new rows always pop up even after deleted
hi all anyone have similiar problems? these empty rows keep appeared even after deletion. i havent create any automation and the properties also cannot be seen
-
Task duration as a function of the number of resources
Hello! Can task duration be calculated as a function of the number of resources? If one person takes three weeks then allocating three people should complete the task in one week, etc. This should be easy but I can't find this capability. I'd appreciate suggestions on how to do this. Thank you, Michael
-
Record the number of days based on another coloumn
I have a drop-down list with a list of statuses. Is there a way to use a formula or something to record the number of days a record was in a particular status? Any help is appreciated. Thanks!
