I think this is simple formula - but can’t figure it out. I want a formula where if checkbox is checked, it puts the same amount as another extended column that I have. If checkbox 1, then take # from…
I'm trying to find an app that automates our processes — finance to training to sales. I want to create a template that I can that I use every time there is a new job to do. When training is booked fo…
I'm looking to find the the sumif of current week for a specific matter. However the matter is only listed in the parent row =SUMIFS({Test Hours}, {Week Number}, @cell = (WEEKNUMBER(TODAY())), {Matter…
Has anybody used SmartSheet to mass distribute a calendar with multiple events shown and connected independent links so people can select and register for each of the separate events?
I currently have multiple employees who update a lot of projects using forms and recurring weekly update requests. Each project has its own row. Those projects often get reassigned, and new ones are r…
Hi all, I'm fairly new to smartsheet (with no Excel experience either). Here's my situation. I'm tracking POs-- first, you enter in a PO amount, and in subsequent columns what you invoice per-month. T…
Hello, I have several sheets. One every month with at least 2000 rows per month. I import the information from an outside source via Excel. Long story short, there is a high probably ability of gettin…
Hi, I've read through a few threads and I am unable to re-create a simple countdown formula. I keep getting an #INVALID OPERATION error. Am I missing something? Please help! Thank you!
Wondering if there is a way when adding multiple resources to a single task to add also multiple allocation percentages? For example if i am tasking A & B on task 1, but i want A to be at 20% and B to…
