-
Ipad attachment problem
Users have been having a problem since yesterday, when uploading attachments from Ipad, they show up in the wrong rows or attach to the sheet rather than the rows, even though nothing has changed in the way they upload attachments. I've told the users to keep a close eye when they upload attachments to make sure they…
-
Sheet Summary Formula for Counting Blank Cells
Hi All, I have been playing with this formula for an hour and figured I need to get some help. My formula is below and a screenshot of the page is below that. What do I need to do to get a value other than 0 (which is not accurate)? Thanks for the assistance.
-
Update a Report Filter Automatically
I have several reports that are based on accounts and task completion. The filter that I have been using for "At Risk" tasks is Date > 1/1/24. However, I am going to want to move it to Date 4/1/24. Instead of updating my filter on every report for every account, is there a way to automate this task?
-
Parent Child formula for Checkboxes
Hello, I am working on a checkbox column formula for a sheet that will function as a roll up but will not automatically check the lowest children. Currently I have this: =IF(COUNTIFS(CHILDREN(), 1) = COUNT(CHILDREN(Tasks@row)), 1) That formula works, but you have to manually add it to each parent row. I would rather have…
-
Hi everybody,
I have one Business Plan Licensed User, I shared a worksheet with a contact from my contact list, and when I was approving his user appears a message telling me, like I need to add another user licensed to my Licensed User, so I stopped the process. My Business Plan allows to have unlimited editors, so I don't know the…
-
Visual Status Bar based on drop down criteria
Hello everyone, I need your help in creating a formula that checks against the drop-down menu of a column and then returns a visual bar or symbol based on that drop-down. Example: Select Outline created in the status, the output into another column would be X----- Second example: Draft complete is in the status and the…
-
Smartsheet calendar with google calendar integration - customize text in body of description
I've integrated a smartsheet calendar with google calendar, however anytime I make a change or save the smartsheet, it changes all existing events description to default text "this is a smartsheet, access the link here". Is there a way to remove any description text when creating a calendar even in smartsheet? My…
-
Copy Column to another sheet
Is there any option to copy a specific column to another sheet after met the criteria (Workflow).
-
Help on my formula please
Hi all , Formula not working as shown be;ow , can you help with what i have done wrong please? Thanks =IF([Quote SLA For Remedial]@row, <>"", "Awaiting Quote", IF([Remedial/CAFM Job Number]@row, <>"", "Yes", IF([Remedial/CAFM Job Number]@row, "", "No")))
-
conditional formatting for Duplicate Values
Excel have Conditional formatting option for highlight the duplicate values. Does this currently exist as an option for Smartsheets or could this be added?