-
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…
-
Locating the parent of a parent
I am trying to take the value from the primary column of a level 0 parent and insert it into another column in a level 2 child. =PARENT([Task Name]@row) works fine when there is only level 0 and level 1. Something like parent of a parent is what I have imagined would work, but =parent(PARENT([Task Name]@row)) is…
-
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!
