Dell55 — Smartsheet Community

讨论

5, \"yes\", IF(AND([Seen this week ]@row + [Seen Last week]@row + [Seen Last 2 Weeks]@row + [Seen Last 3 Weeks]@row = 5, \"hold\", IF(AND([Seen this week ]@row + [Seen Last week]@row + [Seen Last 2 Weeks]@row + [Seen Last 3…","categoryID":322,"dateInserted":"2022-09-20T22:02:11+00:00","dateUpdated":null,"dateLastComment":"2022-09-21T20:34:58+00:00","insertUserID":151668,"insertUser":{"userID":151668,"name":"Dell55","url":"https:\/\/community.smartsheet.com\/profile\/Dell55","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!3D8mf0eoi_s!nHsn3w-RCzs!IXb4eKDj6uT","dateLastActive":"2023-08-29T00:23:56+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭"},"updateUserID":null,"lastUserID":151668,"lastUser":{"userID":151668,"name":"Dell55","url":"https:\/\/community.smartsheet.com\/profile\/Dell55","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!3D8mf0eoi_s!nHsn3w-RCzs!IXb4eKDj6uT","dateLastActive":"2023-08-29T00:23:56+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":3,"countViews":104,"score":null,"hot":3327505629,"url":"https:\/\/community.smartsheet.com\/discussion\/95619\/if-with-multiple-contingencies","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/95619\/if-with-multiple-contingencies","format":"Rich","groupID":null,"statusID":3,"attributes":{"question":{"status":"accepted","dateAccepted":"2022-09-21T20:49:46+00:00","dateAnswered":"2022-09-21T04:25:17+00:00","acceptedAnswers":[]}},"bookmarked":false,"unread":false,"category":{"categoryID":322,"name":"Formulas and Functions","url":"https:\/\/community.smartsheet.com\/categories\/formulas-and-functions","allowedDiscussionTypes":[]},"tags":[{"tagID":254,"urlcode":"formulas","name":"Formulas"}],"reactions":[{"tagID":3,"urlcode":"Promote","name":"Promote","class":"Positive","hasReacted":false,"reactionValue":5,"count":0},{"tagID":5,"urlcode":"Insightful","name":"Insightful","class":"Positive","hasReacted":false,"reactionValue":1,"count":0},{"tagID":11,"urlcode":"Up","name":"Vote Up","class":"Positive","hasReacted":false,"reactionValue":1,"count":0},{"tagID":13,"urlcode":"Awesome","name":"Awesome","class":"Positive","hasReacted":false,"reactionValue":1,"count":0}]},{"discussionID":95282,"type":"question","name":"Sumifs syntax help","excerpt":"trying to get a sum for the number of OT sessions for each student in a given week not sure what's wrong with my formula =SUMIFS([Todays Week ]@row, {Week Number}, [Student Code]@row, {OT Student Code}, {OT Sessions},=>1) I'm trying to sum the number in the OT session column of a separate sheet if the week number matches…","categoryID":322,"dateInserted":"2022-09-12T21:38:04+00:00","dateUpdated":null,"dateLastComment":"2022-09-16T20:22:56+00:00","insertUserID":151668,"insertUser":{"userID":151668,"name":"Dell55","url":"https:\/\/community.smartsheet.com\/profile\/Dell55","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!3D8mf0eoi_s!nHsn3w-RCzs!IXb4eKDj6uT","dateLastActive":"2023-08-29T00:23:56+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭"},"updateUserID":null,"lastUserID":151668,"lastUser":{"userID":151668,"name":"Dell55","url":"https:\/\/community.smartsheet.com\/profile\/Dell55","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!3D8mf0eoi_s!nHsn3w-RCzs!IXb4eKDj6uT","dateLastActive":"2023-08-29T00:23:56+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":2,"countViews":129,"score":null,"hot":3326379660,"url":"https:\/\/community.smartsheet.com\/discussion\/95282\/sumifs-syntax-help","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/95282\/sumifs-syntax-help","format":"Rich","groupID":null,"statusID":3,"attributes":{"question":{"status":"accepted","dateAccepted":"2022-09-16T20:22:07+00:00","dateAnswered":"2022-09-12T23:42:05+00:00","acceptedAnswers":[]}},"bookmarked":false,"unread":false,"category":{"categoryID":322,"name":"Formulas and Functions","url":"https:\/\/community.smartsheet.com\/categories\/formulas-and-functions","allowedDiscussionTypes":[]},"tags":[{"tagID":254,"urlcode":"formulas","name":"Formulas"}],"reactions":[{"tagID":3,"urlcode":"Promote","name":"Promote","class":"Positive","hasReacted":false,"reactionValue":5,"count":0},{"tagID":5,"urlcode":"Insightful","name":"Insightful","class":"Positive","hasReacted":false,"reactionValue":1,"count":0},{"tagID":11,"urlcode":"Up","name":"Vote Up","class":"Positive","hasReacted":false,"reactionValue":1,"count":0},{"tagID":13,"urlcode":"Awesome","name":"Awesome","class":"Positive","hasReacted":false,"reactionValue":1,"count":0}]}],"title":null,"subtitle":null,"description":null,"viewAllUrl":null,"isMainContent":false,"noCheckboxes":true}">

"The form you are attempting to access is no longer active."
I have 2 forms for my 2 primary Smartsheets that I depend on and use regularly. All of a sudden both sheets are not working and returning this message "The form you are attempting to access is no longer active." I've gone gone into settings to flip the "active"/"inactive toggle. tried resending the link to myself. But it…
temp access to an old Smartsheet
it looks like my company canceled the Smartsheet license program for the office and i didn't know. This is bad news cause we still need all that data. do you know if there is a any process to gain temporary access to a Smartsheet license? Dell
simple COUNTIF Sheet Summery formula
如果需要帮助mple formula for a sheet summary =COUNTIF([IEP Status], "NEW (not signed)", "Active", "Active (Needs Att.)") something is wrong with the formatting I want to count number rows that contain these specific drop down list values. I put the values in quotes but the parentheses from the drop down values…
fixed durration vs. fixed start/end dates (deadlines) with gantt chart
I'm trying to develop a template for scheduling the 30 to 60 sub tasks in each of the many year long projects I'm managing. Im hoping to use a dashboard to tack all the projects at once. but for the template id like to set up an easily adjusted Gantt calendar. There are dates that are subject to fixed dates like quarterly…
Scheduling 30-60 task annual projects with just 200 whole working days per year
I want to develop a template sheet that I can use to easily schedule out 30 to 60 different 30 min subtasks evenly over 200 specific available work days each year. I started out trying to set up a gantt view row with "200d" working day duration then removing sat/sun, and inputting 62 other Non-working days in gantt view…
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 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
Archiving rows with formulas that reference other sheets
I've build a pretty large Smartsheet for tracking data yearly contracts for each of my 60-70 clients on therapy caseload with formulas in each row that reference other sheets and pull numbers from daily log forms. I need a simple process for archiving a row when the year contract is complete. I want to save a snapshot of…
IF with multiple contingencies
=IF([Seen this week ]@row + [Seen Last week]@row + [Seen Last 2 Weeks]@row + [Seen Last 3 Weeks]@row > 5, "yes", IF(AND([Seen this week ]@row + [Seen Last week]@row + [Seen Last 2 Weeks]@row + [Seen Last 3 Weeks]@row = 5, "hold", IF(AND([Seen this week ]@row + [Seen Last week]@row + [Seen Last 2 Weeks]@row + [Seen Last 3…
Sumifs syntax help
trying to get a sum for the number of OT sessions for each student in a given week not sure what's wrong with my formula =SUMIFS([Todays Week ]@row, {Week Number}, [Student Code]@row, {OT Student Code}, {OT Sessions},=>1) I'm trying to sum the number in the OT session column of a separate sheet if the week number matches…

More Discussions

Dell55✭✭✭

讨论