-
Move Rows Doesn't Work When Cell is Linked?
I am trying to setup a process using Smartsheet and the move row function doesn't seem to work. My process includes 2 sheets: 1. Sheet A 2. Sheet B When I change a specific cell in Sheet A, there is an automation to copy the row to Sheet B, which works perfect. Then, I have a DataMesh setup where the Source Sheet is Sheet…
-
Creating Due Dates (Monthly & Quarterly)
Greetings I have been asked by a colleague to build a smartsheet that sets out a list of tasks to be completed and the due date of each task (to be used primarily in calendar view by the colleague to plan her time). Her due date for a task is either made with reference to: (i) a business day in a particular month (i.e.…
-
Formula in Date Column
Hello, I am trying to get a date value from another sheet in a date column using Index(Collect(.......),1) function. However, every time I add a formula in date column it converts to text by adding a ' sign. For Example: Sheet1 has following columns: Location Project Start Date End Date ... .. .. .. I want to move Start…
-
Web form bug?
Is anyone else having an issue with web forms auto populating a date? See screenshot below. It's auto populating a date in the year "0002". I have the form field setup to be blank. See second screenshot.
-
Accessing sheets within workspaces using the Smartsheet API
Hi! I am attempting to pull sheets from inside one of my workspaces using the api, but have run into issues passing both the workspace id and sheet id to GET in sequence. For example, I am able to use GET /workspaces/{workspaceid}to retrieve the workspace object and its contents, but how would I go about using a GET…
-
Approval Workflow
Hi there ; I would like to learn that ; as you know when we create a approval workflow system is taking an action about one row , and sends form atc. according to that considered row, but i wonder is it possible to send one form but includes many row's information and approver can approve those many rows at the same time ?…
-
Sum Column Divided by Two Summed Columns
This is the formula I'm using, but I'm getting unparseable: =(SUM([Actual final door count]:[Actual final door count])) / SUM([Inspection & minor repair labor hours]:[Inspection & minor repair labor hours] + [Repair labor hours (return trip)]:[Repair labor hours (return trip)])) Here is what the data looks like: I need the…
-
Formula for tasks/Sheet Summary
So I'm at another roadblock so bare with me... I have a current formula that tracks the prior day's target tasks and a formula that tracks the prior day's completed tasks. However I want to incorporate my overdue tasks in these formulas as they still need to be accounted for. I was able to add my overdue tasks to my daily…
-
Multiple Select Contact Column/Sheet Summary
I'm looking for a formula that I can use in Sheet Summary to identify individuals assigned to the same task via a multiple select contact column. The below is what I currently use to track daily tasks for individuals. Target Tasks =COUNTIFS([Due Date]:[Due Date], =TODAY(), [Critical Ops.]:[Critical Ops.], ="Yes",…
-
List one sheet to another when column contains text
Hi Smartsheet Guru's I have a sheet with many columns and formulas - which is increasing in size and slowing down. I would like to offboard some of the formulas to another sheet. Therefore, I would like to create a formula that looks in column Gap ID and if it has text (not empty) then the formula would copy the text in…
