-
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…
-
Could I change the border colors in a sheet?
I'm trying to shade column to the lightest gray, however that made the borders invisible as they are the same color, anyway I could change the border color to black? see below for example:
-
Auto Save
I just noticed that all of my sheets are now auto saving. When did this start? Not sure if this is a good thing or bad thing.
-
Can I make a person an Admin on a report but make them only as an Editor or View on base sheet?
I have created multiple reports from a base sheet but do I am wondering if one person can have different access levels to sheet and base sheet. I know they need access to the base sheet in order to view and edit information the report but I don't want them to have access to edit or share the base sheet.