-
Default Cell Formatting
I have this weird issue I hope someone can help with. One of our PMs had used a background fill color on some rows. We wanted to pull a report of these rows but did not want the coloring in there. We reformatted the sheet to sheet be a white background fill and pulled the report. This worked great except for the system…
-
WorkSpace Security w/subfolders
When will we be able to add several subfolders to a Workspace, and decide who gets access to each sub -folder instead of always inheriting Will we be able to share folders under sheets in the near future
-
IF criteria on two fields
I have two IF statements that I can get to work by themselves but not together. Here is the first one by itself. The formula is in a cell called “# of Days Past Due”. Both Part A and Part B work separately. Part A - If the Date payment received is blank, it takes TODAYs date and subtracts from the Claim date, else 0.…
-
Filter to see hours per person
Hi Smartsheet, I have a column 'Assigned to' that lists employees name for specifc tasks. I also have a column that is 'Outsourced Hours'. When I filter on a specific employee it does not show me the total hours they have been outsourced. I would like the ability choose an assignee and see their total hours. Any…
-
SUMIFS Multiple Criteria
I'm beating myself up. Im trying to calculate the sum of tasks, that if they have the status "Submitted" and the submitted date is in March then it would calculate the value. Currently it is saying its #unparseable =SUMIFS([Submitted ($)]:[Submitted ($)], [Status]:[Status], "Submitted", [Date Submitted]:[Date Submitted],…
-
Customize tab order
I have several projects that I am into every day. How can I have these auto-populate the screen instead of other irrelevant tabs?
-
Question on Sight image size (Resolved)
I'm trying to build a banner-like image across either 3/4 or the full width of the screen. The height will be some small portion (1/4 or much less) of the width. Is there an algorithm I can use to determine canvas size of the image I'm using? I don't want to spend much more time with trial and error on what is likely to be…
-
I cannot get the search query api to work - it gives partial matches
I've tried using postman and single and double quotes do not make any difference either I can filter the results but it seems like i must be doing something wrong https://api.smartsheet.com/2.0/search/sheets/798272320235396?query="'Elliott'" returns { "results": [ { "text": "White cottage", "objectType": "row", "objectId":…
-
ghost sheets auto loading upon sign in ?
A business partner gave me access to this site and originally created a smartsheet called GS Master Directory (View Only). From my understanding this sheet no longer exist and although each day I close it before logging out of my account, it still auto loads the next day. The sheet is not that large in my opinion however…
-
If Statements and Calculations
I'm trying to calculate a cost based on whether a field is marked (and another field that contains quantity) or not. So, if field A is marked (checkbox), then multiply $5 x Field B. If field A is not marked, then multiply $4 x Field B. Is there a formula for this? Thank you, Jennifer