-
RAG Roll-up formula
Could anyone help me with a formula I'm trying to perfect. I am trying to create a formula that automatically captures RAG status for Children Rows and how this is communicated to the Parent rows. The plan is essentially structured like this (images are attached): * Project Plan Summary (Senior parent)* Main Tasks…
-
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…
-
Sheet exceeded the maximum recommended size
Has anyone received this error message before? What are the options for large data?
-
Image upload to multiple cells through API integration
Hi everyone 👋 I developed a Python-based application that enables uploading images directly to cells (instead of row attachments), allowing for more structured and visually organized data within sheets. Key highlights: Upload images directly to specific cells Built using Python and Smartsheet API Designed for structured,…
-
Smartsheet formula saving error
I have been using a formula in smartsheet column however from last week i have tried to update the formula and when i save the sheet the following happens please help as soon as possible
-
Options to display all formulas/functions in a sheet
Hi Community, I am a new user and would like to know if there is a way to view the formulas/functions within a sheet either as an ad hoc toggle on/off feature/shortcut or by leveraging the report builder. I understand that we could copy the formula/function body as text to a hidden column for reference or reporting.…
-
How to calculate the number of submittals completed each day.
I am currently working on a construction project where I am tracking Request for Information (RFI) for our subcontractors. I can get up to 30 RFIs a day. My question is what is the best way to track how many I process daily? Is there a Countif formula or a DataMesh process that works best?
-
Error when opening a sheet
As I finished working on a sheet last night I got an error message saying to log off and back on. I logged off for the night and now we’re getting the same error message when trying to open the sheet. When we use the search feature it doesn’t appear. When we go to the folder it’s there, but we get the error message when…
-
Budget Management
All I wanted to show you how I am using smartsheet to keep my budget reporting in real-time. I have 3 sheets 1) A Budget sheet 2) An Invoice Sheet 3) A Project Action Log The purposes are as follows Budget sheet This houses my line my approved budget using MasterFormat and also my Non-construction costs like Architect…
-
Uploads that work if you close the app
I need photo uploads on mobile to be more robust. This is a combination of background persistent upload, upload retry, upload queue, and deferred upload. I am trying to get users to submit photos to specific lines in a sheet so that I can track and verify which tasks are completed. If they attempt an upload and their…