-
Why do the dates change in the fillable PDF?
Hello I am making fillable PDF and I was trying to put a birthday in them and when it loaded it came out as (Not real) 04/05/23. I have changed it in the smart sheet cells where the dates read out as April 5, 2023 but when it hits the fillable PDF it changes to just numbers. I need it to be spelled out does anyone know why…
-
Is there a way to track workflows
Recently, we have had a couple of team members claim that Smart Sheet did not send the automatic update request as part of a workflow. Is there any way to show when exactly smart sheet would have sent that out?
-
Help on Or/Contains formula
I am in the need of some help as I am banging my head against the wall trying different formula options here. I wish to grab all characters left of a certain character combination (" -") from a drop-down cell. For instance, I wish to grab "Hosted Event (physical)" from the drop-down cell with "Hosted Event (physical) -…
-
COUNT(DISTINCT(COLLECT - Counting a value per employee
Hi, I'm trying to count how many values I have for certain people. I have two values that are assigned to the employees daily, for each day we have a value of either "Y" or "N". I want to count how many "Y" an employee has. I'm getting this information from a big database, to have it summarized in a small one. I've tried a…
-
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…
-
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…
-
Change Milestone Diamond Color
Hi everyone, I realized this question was asked in 2020. Are there any updates on having milestone diamonds in a different color? Appreciate any suggestions! 😀
-
Within a SUMIFS formular, I'm trying to add on to a count if a contact appears in a multi-contact or
-
How can I add a number of days to a date column in the same sheet?
Hi! I currently have a column that is supposed to add 14 days to another date column in the same sheet. The formula I'm using is: =["Date Column"] + 14 However, what I keep getting is "Apr 21, 2020 3:10 PM14". Both columns are date columns. Thanks so much in advance!
-
Many columns on sheet - not all appear as options in a report?
Happy faux Friday! I'm working with a very large (about 30 columns) data sheet in Smartsheet. I'd envisioned it as the one source of truth to feed multiple reports. The problem is the latest report I'm trying to build, the 5 columns that I need to appear and provide data, are not showing up in the columns from which I can…