-
Smartsheet Internal Audit
Hi Community, My Region of our organization is going through SOC2 audit and I am assuming we might be audited on Smartsheet also. I want to ensure that all my teams have updated all relevant Smartsheets and have deleted outdated information from sheets and workspaces. I want to monitor such incomplete or out of date…
-
Reporting/dashboard on form entries
Our Referrals departments has recently started utilizing a smartsheet form to track key information on each referral that comes into our hospice. Each team member completes & submits the form when they get a referral. I have the sheet set to automatically date/time stamp each row as it comes in. The department heads are…
-
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…
-
index and match formula that works in some places and not others
Hi, I have an index and match formula that works in some places and not others. I tried to attach a screen show that shows what I am trying to do along with this description. My formula in the Time and Attendance row works as expected. The data for overall status, scope, timeline, resources and funding are matched and…
-
Convert Numbers (Days) to To Year/Month
I'm trying to convert number of days to year and month. In excel I would use the following formula =DATEDIF(0,[Days closed]11,"y") &" years, "&DATEDIF(0,[Days closed]11,"ym") &" months" Though this formula does not work in smartsheet is there another way to do this
-
Is there a way to combine these two formulas? IF and NETDAYS, use of TODAY function
I would like to return a value based on the total number of Medicare Days used prior to admission, plus the total days elapsed since admission to calculate day 100, or benefit exhaust date. I've worked out the individual pieces but I'm having trouble combining the two. In the Days Remaining Column, I have this: =100 -…
-
Hello from Jo based in Australia
Hi everyone - Looking forward to becoming an active member of this community. My career is in MedTech and new business startups, specifically in Sales Leadership/Management and Business Development. Introduced to Smartsheet 18 months and am keen to transition into PM. Looking forward to learning more and would appreciate…
-
Certified Smartsheet user on the look out
Hey friends, Anyone hiring experienced Smartsheet user, if so let me know! 😁 I've been using Smartsheet for 6 years, it's so much a part of my daily work productivity and I'd like to seek out another opportunity where I could transition my skills and background in program management into. I've gain so much knowledge and…
-
Email Notification - Limits to Columns in Message?
Our clinic managers perform a monthly Joint Commission readiness walk-through for each clinic (approx 125). I have built a form for them to document their results for each question - Compliant vs. Non-Compliant. When setting up a email notification to send the results to the regional directors, there seems to be a…
-
index match quandary
I'm using this formula to return a student specific date from another sheet based on a student code =INDEX({Student Code from info sheet}, [Student Code]@row, {IEP date from info Sheet}) it says #INVALID DATA TYPE I've used this INDEX MATCH and this type of formula before and I'm not sure why its not working
