-
Sum with multiple conditions
Hi community i'm trying to create a formula that calculate a sum in a column based on may criteria. here is a screenshot of the affected column i want to calculate the "volume cumul" (sum of volume collected) based on Week Active should be "This Week" or "Next Week" same Unique ID should be calculated together if Unique ID…
-
Changes to license requirements for Editing
I have hundreds of hours in building sheets that link multiple teams. This was all done on the premise that we wouldn't need 100s of licenses for simple cell updates. All of a sudden I am getting bombarded by users saying they cant edit only to find out we now need licenses? I love the Smartsheet core product but this has…
-
Workspace Sharing Question
Hi Everyone, We currently have a Smartsheet business plan and we wanted to know if it was possible to invite people into workspaces, but limiting what they see in the workspace. A few users would like to be able to edit some sheets within this workspace, but it is not allowed since their accounts are set as viewers. Is…
-
Smartsheet API List Workspace Children
Hello, I'm trying to use the Smartsheet API to get a list of sheets in a workspace using: https://api.smartsheet.com/2.0/workspaces/{workspaceId}/ However, my workspaces are organized with folders and this only returns the top level folder and nothing else. How can I have this return every child object in the workspace no…
-
Creating a folder in SharePoint from Smartsheet and naming it based on row data
I'm a Power Automate Novice and I'm not experienced in expressions. I am building a data flow in Power Automate to create a new Sharepoint folder when a new row is created in my smartsheet. I can get to the stage of creating a new folder however I would like to name it based on cell data in the row. I have tried to use the…
-
creating mid-task lag?
In construction scheduling, we often have weather delays, lag when subs are working out of town, etc in which we need to create a delay mid-task. i.e., contractor A starts a task on 1/2, is delayed until 1/9 due to cold weather than picks back up and completes the task 7 days later than originally anticipated. Is there a…
-
Returning a Percentage Based on Particular Criteria
Hi I am trying to work out a percentage for some KPIs. I have a sheet I am recording various KPI entries on (see below) I have a metrics sheet set up so, I can break the KPI results down by month by referencing this sheet. Taking KPI 1 (in the example shown above), I need a formula that will return a percentage of the…
-
Displaying an overall completion % within a dashboard
Hi all, Is it possible to display some sort of graphic like this within a dashboard? I'd be taking data from a form and gathering total numbers of of "yes" and "non" questions to get the numerator and denominator for each row or column in the picture. I think I could do the metric sheet part of this task no problem, but…
-
Back up/ attachments
When I am going to back up some attachments, it didn't restore all the attachment that deleted 3 days ago. How can I back up with all the attachment restored? Looking forward to you help, thank you in advance.
-
Allow linked cells to trigger workflows
Just as the title says. It's really frustrating when you want linked cells to trigger a workflow but you can't.