-
Can't compare two string values
So I'm using this formula to try and compare two "String" values. In this situation, some values in Column 2/3 will be numerical only and some will have text. I have a helper column checking that both are string values but it still won't match. I've tried with collect and contains too. I'm trying to pull the value in…
-
Best Way to Pull A Ton of Data
Hello Community, I have recently been given the challenge of pulling a ton of data from a source sheet to a target sheet, and am trying to figure out the best way to pull all the data efficiently and not run out of space too quick. Unfortunately we cannot use data mesh because each row has 7 target columns to pull from.…
-
% Complete showing 10,000% instead of 100%
Hi, I noticed few week ago that when I enter 100 in my %Complete column it shows 10,000% as value. It looks like it add zero to my entered number. Does anyone know how I can change the setting back to what it used to be meaning if I enter 100% it shows 100%. Regards, Audrey
-
Source Sheet & Dynamic View Dates Don't Match
I'm building a dynamic view and have pulled in the date column and it doesn't match my source sheet. Source sheet used a column type of "Created Date" and displays as 03/15/23 1:19 PM. Dynamic View shows as 2023-03-06T21:38:58Z. Is there a way to show the date in my dynamic view similar to what the sheet shows?
-
Omit records with No data on Charts
I have a Workspace with a form that feeds into a sheet Then I have a calculations sheet that adds up everything (most of which us SUMIF). Now a few of these Workstreams (which are in a dropdown list on my form/main sheet do NOT have any data currently associated with them. But that will change. And like I said these…
-
therapy caseload/client data tracking... anyone have success with smartsheet?
Hi all, I'm an Occupational therapist for kids with autism. After the pandemic rendered our therapy office paper data filing system obsolete(I couldn't access it from home), I determined to make the move to digital client records Smart sheet seemed like a user friendly option over excel I'm looking for a basic set up that…
-
Merged: Five color symbols
This discussion has been merged.
-
Summary Sheet/Report/Cards/?
I have no idea how to even approach this. I have played with using a report summarize some data using different views, but the formatting so limiting that I cannot get anything useful. I have a main sheet that tracks evaluations. For this summary I want to show just a small bit of data. I have columns that I want to use in…
-
Sheet to Sheet Cell Updates
I have a sheet with a status column. I would like to have the statuses in that column automatically updated based on when users make their updates in three other sheets. I thought I could use a workflow but I don't want to update the full row from sheet to sheet, only the cells in the status column. What is the best way?
-
Dropdowns in a dashboard, is it possible?
I have one sheet that has metrics for a few of my employees, I was hoping there was a way to get the drop down menu function for each employee transferred onto a Dashboard highlighting everyone's metrics. *The drop downs show their total sales for each month, and even quarter, down to how many projects they have completed…
