-
Converting 2020-05-20T12:38:08.063 to a date format
Hi Everyone, I am using data uploader and importing an excel file that uses this date/time format 2020-05-20T12:38:08.063. Looking for suggestions on how to extract the date efficiently. At the point of export into excel there is no option to remove the time stamp so I'm kinda stuck there. Thanks in advance !
-
Trouble with Formula for RYG/Health/Status Columns
Hi There, I'm brand new to Smart Sheet and still learning the abundance of inner workings - hoping to find some help with what is probably an easy formula but I can't seem to get it right! I'm trying to change the color of the RYG ball under my 'Health' column based on the 'Status' column. For instance: Red = Canceled/Not…
-
Is there a way to change info in a master sheet to be reflected in sub sheets?
Hi all! New to Smartsheet so please bear with me and my (maybe perhaps)silly question but one I haven't been able to find a solution to. I am using Smartsheet to compile online student registrations. My format: I have one "Master Sheet" where all of the registrations flow into. I have created "sub" sheets, and created work…
-
Alert based values in two columns
Hi, I have a total inventory column and a reorder point column. I'm trying to make my sheet alert someone when the inventory falls below the reorder point. I can't seem to figure out how. I know I'll need a helper column. I thought I'd do a check box and then have the alert set to when the checkbox is checked. But I can't…
-
Basic RAG Calculation formula based off completion % in project schedule
Hello All, I would like to know if anyone knows how to set up a basic RAG formula based on completion % and the schedule date. Custom criteria would be as follows: If % Complete = 100, return Blue If it's not scheduled to start yet, return Clear/Grey If past the scheduled finish date and % complete is less than 100%,…
-
Conditional Logic in Smartforms (AKA Cascading Dropdowns)
We all love a Freebie? OUR API development team get lots of requests for automation which is the basis of our Smarter Mini Control Center 12 Apps, but one request we have been unable to fulfill so far (unless we use Appsheet with Smartsheet) is the need for Conditional logic or Cascading Dropdowns when completing forms in…
-
Value in one sheet create a "populate" trigger in another sheet
Good afternoon We have a bid invite sheet that we fill out with prospective jobs (each row is a prospective job) to bid on. It has multiple columns of Data that if we decide to bid on the job would need to be transferred to our sales/estimating sheet. If we had a YES/No drop down column and we choose YES is there a way to…
-
Apostrophe added to formula that is pushed from Zapier
We’re using a sheet for ticket tracking. Issues come in via a form, manual entry, or the Gmail Add-on. We’re using hierarchies to track To Dos as tasks. I use a simple formula to tell me if a row is a task or a parent. =COUNT(ANCESTORS()) I use the value for formatting and for accurate issue counts as I only want to count…
-
Need a formula to count how many of each Support Type is assigned to each Assignee.
For example, for the DFM/DDFM Support Type, I would like to know that there are: Communication: (1) Ashley Pierce (1) Tanner May Proposal Review: (1) Alexa Briggs (2) Ashley Pierce
-
Join columns, not side by side, and skip columns with no info
I am looking to join multiple columns using a "-" as deliminator and I dont have the columns side by side to select range and use Join function. I also want it to skip columns that are blank. Also - I notice in Smartsheet i have to use date format 10/15/2020 is there a way to change it to 10-15-20 (I use "-" as separator…